There’s a lot of evidence in clinical trials with MDMA and psilocybin mushrooms (which have a lot of similarity to LSD) regarding efficacy for treating various psychological conditions when used in a safe and guided setting.

Pretty sure we have nothing of the sort for alcohol. Just the opposite, in fact, like this article.

I can’t speak for THC.

I wouldn’t say that this evidence makes any substance more morally “superior” to any other, it all depends on the context of use.