Well...Maybe not.
If you are fortunate enough to be among those who do not "tolerate" alcohol, then you will never be faced with the dilemma of having to discipline yourself to avoid it.
Some people just become very sleepy after a drink or two and find themselves seeking a place to sleep long before becoming intoxicated. Others, who are tolerant of alcohol, are able to consume alcohol for hours on end to the exclusion of sleep or food. The state of intoxication simply keeps rising, possibly getting to the point of lethal poisoning.
How do I know this? Suffice it to say that I have not had a drink in almost thirty years. For some very good reasons.
We may be faced someday with the perfect intoxicant. One which conveys feelings of happiness, contentment, and joy with none of the side-effects normally associated with such drugs. What then? Will there still be a moral stigma attached to getting "high" if there is no violence or negligent activity as a consequence?
Well, I don't know about perfect but an occasional bong hit never hurt me any.
Of course the WOD Lifestyle Nazis will be along shortly to answer the second part of your question.