To be clear, I think alcohol, cocaine, and even caffeine do cause significant stressors on a life, to varying degrees and in different ways. They just aren't mutually exclusively with being highly productive in any given field.
Alcohol may be better aligned with physical labor, where there's some benefit from not noticing as much when you hurt + adrenaline spikes as it wears off. Cocaine probably aligns better with writing, when word vomit helps get something down that can later be edited. Neither has a particularly great track record with living a happy life.
Sometimes taboo makes it worse than it needs to be, though. An addiction, treated as a crime, leads to an even more desperate addict.
Alcohol may be better aligned with physical labor, where there's some benefit from not noticing as much when you hurt + adrenaline spikes as it wears off. Cocaine probably aligns better with writing, when word vomit helps get something down that can later be edited. Neither has a particularly great track record with living a happy life.
Sometimes taboo makes it worse than it needs to be, though. An addiction, treated as a crime, leads to an even more desperate addict.