No it doesn't, not for the overwhelming majority of people. It helps in the illusion of creativity, most commonly the effect is dulled critical faculties and the acceptance of sub-par work which has to be redone when more clear headed.

Alcohol is a recreational drug, its association with industries such as journalism has to do with working wierd hours and drugging contacts to get leads, not with productivity, and certainly not with creativity.