No, what you saw were users who used to a degree of irresponsibility that LE got involved. LE in general often has occasion to deal with drunks, but we would be flat wrong in supposing that most users of the addictive mind-altering drug alcohol are like those encountered by LE.
And what did you see dope do to the community?
Run down property,
Dope didn't do that, property owners did - many property owners do so without being on dope, and many who are on dope don't.
elder parents/relatives being taken advantage of,
Dope didn't do that, people did - many people do so without being on dope, and many who are on dope don't.
child abuse/neglect,
Yes, some children are victimized when their parents use drugs - including alcohol - to the point of being unable to care for them. If that's not sufficient reason to ban the drug alcohol, it's also not sufficient reason to ban other drugs.
lost time/wages (same for drunks).
How is this something done "to the community"?
“Good” users (a paradox)
Are good users of the drug alcohol a paradox?
are affected by the bad ones through things like exposure to stronger drugs and bad behaviors, the cavalier attitude toward authority (like dims and libertarians).
So it's government's job to protect people from exposure to temptations?! And cavalier attitudes?!? I think you're looking for Democratic Underground or Daily Kos - this is a limited-government site.
I feel the same about alcohol. If your life sucks enough you need a chronic escape then I pity you.
Besides it worked for our current CiC so it must be good.
Trust me I am more limited government than you have a clue about. I just know what destroys a society besides apathy.