Bob Dylan - ...'everybody must get stoned' - weed, uppers, twisters, and more
John Lennon - Lucy in the sky with diamonds - LSD
David Bowie - the bulk of his songs - cocaine
Oasis - everything prior to 1997
Berlioz wrote his Symphonie Fantastique under the influence of opium.
Miles Davis - Bitches Brew - heroin(?)