Alcohol is so terrible, especially when severely abused, that "better than alcohol" absolutely cannot be a meaningful standard for being a proper treatment.

> there are many other "drugs" that people would oppose that do not make you dysfunctional.

People oppose these drugs because they do tend to make you dysfunctional, at least when abused. And when people are severely depressed, the depression itself makes it more likely that they will abuse their drugs.