No, drug bans have not been outstanding successes, but they've gone very well compared to prohibition of alcohol.
It is at least physically possible to control the distribution of methamphetamine and heroin precursors. The same is not true for alcohol. No alcohol ban could ever work, conceptually.