If you are looking for how alcohol, despite the author acknowledging that alcohol is physically not great for humans, has some positive benefits, I highly recommend checking out the below:

Drunk: How We Sipped, Danced, and Stumbled Our Way to Civilization Hardcover by Edward Slingerland

https://www.amazon.com/Drunk-Sipped-Danced-Stumbled-Civiliza...

The book Drunk spends a lot of time on this very point:

From a long term health perspective, alcohol is very bad or even toxic for humans. That being said, it's been used throughout history for short term benefits ranging from creativity to facilitating social interactions. On the creativity side, the author explicitly states how drinking alcohol can help adults activate child like curiosity and thinking. The idea being that the adult mind has too many inhibitions and the alcohol helps lower those for both internal and external scenarios.

0 - https://www.amazon.com/Drunk-Sipped-Danced-Stumbled-Civiliza...