As such, this would include second-hand smoke, impaired (or delayed) mental function where concentration is required (such as driving), or other activities which may end up requiring an undue amount of compensation from society to balance out
True, but you have to apply the same analysis to all recreational activities. If you're going to ban Cannabis because it's dangerous, you have to ban all other recreations which are more dangerous than Cannabis. Turns out Cannabis is one of the safest recreations, you're more likely to cause long term brain injury by playing football than smoking cannabis.
I start to wonder if the person isn't compensating for a fundamental life issue that is causing them undue stress that needs to be dealt with.
Possibly, but that's their business and you should mind your own.
i simply thought that sobriety was a trait held in high esteem by society in general, along with kindness, charity, and goodwill.
No, not really. A kind drunk is far preferable to a judgmental teetotaler. Kindness is in itself a virtue. Sobriety is at best loosely associated with virtue.