The idea that creative endeavor and mind-altering substances are entwined is one of the great pop-intellectual myths of our time.