What I have seen through the years I'd say that for most the drugs and booze didn't do good. I knew very few that could be stoned and creative but very very few. Most of the users had serious problems after some time. Even the ones who survived hard use, seem to be teetotallers more or less.
This creative thing has some sort of aura in many art circles, although the hardest working successful groups did really much work, ABBA, Beatles, Rolling Stones... The drug use has been, shall I say, glorified like creativity, but are the amounts that big after all? Can you do lots of work if you are stoned all the time, I doubt that. One record is most likely a nice accident, but five or more requires organized work for a long time.