I think there is almost a neo-Prohibitionist attitude coming from some, of late. Though this is largely anecdotal, I think it got ratcheted up by the movement to see marijuana legalized, where weed has often been compared to alcohol.

Aside from this, I agree that the vast majority can enjoy these substances without destroying themselves, leading very productive lives with some of the evident downsides that even casual consumption can bring.