Look, I've never been drunk, never dragged on a cigarette, never took any illicit drug, and hell I seldom even take pain killers. On top of that, I'm quite uncomfortable around people under the influence and I honestly think we'd be better off if people didn't do this shit.
My opposition to making drugs illegal has no relation to my own behavior. It doesn't even have anything to do with me being okay with other people doing it. I used to be in favor of keeping drugs illegal. I understand the visceral feeling that people can have about this, and there can be a sense of anxiety and loss in letting people use drugs, but look, it's counter-intuitive, but after I did enough research I realized that if I really wanted to fight the damage done by drugs, I'd be better off advocating their legalization.
That being said, I do reject this sort of categorical approach to drugs, where we arbitrarily say one thing is a drug and one isn't and using a drug is necessarily bad. That's not how I see it. I hold my ethical position against drug use on the terms of cost-benefit analysis, just like I do with my legal position of allowing people to use them.