alcohol actually lowers inhibition. So what you do not want to do when you're conscious you might do when kind of drunk. That's why people drink, smoke pot, or used to take LSD when they wanted to create their songs.
There are actually ways to get into those states without taking drugs (I consider pot AND alcohol like drugs, maybe the worst ones). Check out Steve VAI's article on his site, there's plenty of advices to create without health hazard...