Not only that, people (well, mammals) want to get high. Alchohol is so much more destructive than weed or MDMA, on both a personal or societal scale. If you’d ban alcohol, people will just sniff glue or start brewing their own bathtub hooch.
Legalization + proper harm reduction + strict enforcement on public (ab)use is ultimately the way. You get a triple win of tax income, freed up police resources and less pressure on the healthcare system.
Which places, and what do you call success?
The only place in the world that seems to have drugs handled properly is Singapore.