Could there be a similar cliff function for alcohol and psychoactive drugs iff used in moderation which may confer to a society an advantage to the detriment of

Could there be a similar cliff function for alcohol and psychoactive drugs iff used in moderation which may confer to a society an advantage to the detriment of individual health. If used above a limit things fall of a cliff. Abstinence however may also be sub-optimal even if best for any individual.