And, even more importantly, the second-order effects that people know they are socially expected to posture the belief that drugs are bad means that people say it all the harder so they look even holier than the person next to them, by being seen to condemn it even harder.
But I never hear anybody say "Omigosh, those guys might have a good time on a therapy drug, that can't be stood for!" That is, frankly, giving them too much credit, much as I hate to say it. Long before they're thinking that deeply about it, they've already hit the "Drugs are BAD!" button and stopped thinking about it. Behold the perils of demanding that nobody be allowed to think about certain things.
How fortunate that this is the only case of that pattern in American culture.
Even if we just stick to ketamine, there are many questions. First, is this better than the current standard of care? Is it better in the short term, long term, or both? How much better? Should we discontinue drugs like SSRIs altogether? Are people dying (committing suicide, in this case) because this is a fringe treatment and not the standard of care?
Second, while we clearly already use it as an anesthetic, we don't know what the effects or dangers might be for this kind of use. Is repeated administration (as seems necessary) a health problem? Are side effects like hallucinations just temporary, or is the brain altered in some way permanently? There are drugs that, the longer and more frequently you take them, the more likely you are to have actual permanent problems (some antipsychotics, for example).
Doing any kind of controlled study with humans is inherently difficult, and in some cases impossible (this is why we know so little about nutrition). But not doing controlled studies and carefully assessing the value of a treatment can be just as catastrophic as ignoring something that seems to work. And you can't go with your gut on these things, or we end up with antivaxers and dead people when we should have just done the study(s) the right way from the start.
Ketamine isn't banned. And it's not all that controlled compared to other drugs (Schedule III). You'd have a harder time running a trial for morphine than you would for ketamine.
They are not reasons for criminal penalties for END USERS who choose to proceed without that data. If a doctor proceeds without that data, sure - they're in a position of trust.
But to throw someone in jail because they injected something into their own body that they personally believed (even erroneously) would help them is complete lunacy.
"Penalties against possession of a drug should not be more damaging to an individual than the use of the drug itself." —Jimmy Carter
Not to mention that that your claim that they don't work is unsubstantiated.