I would never advocate that all pilots become teetotal.
However, it is an option which is worthy of consideration from an individual point of view.
I would respect the right of an individual crew member to imbibe legal "mind altering" substances (within the rules) so long as that person respects my right to abstain.
It is interesting to see how this debate has become polarised.