Who said the benefits are biological?

They means social benefits, not health ones. They even say so in their post.

Is there a single work that attempts to, for example, answer the emotional affects that come from recreational drug use?

You claim that "there aren't based on the biological research" you've read. I do believe you here.

However, have you ever stopped to think that that perhaps the benefits that one derives from consuming alcohol, or other recreational drugs, are outside the realm of what biological sciences can answer? Maybe another field is better positioned to provide you with an illuminating alternative perspective.

The increased dopamine and reduced anxiety resulting from occasional alcohol consumption in moderation is pretty useful in some situations, just like caffeine is useful in others. Relying on either every day however has dramatically diminishing returns that can quickly become a net negative.