Unfortunately, for my drug history, we'd have to invent songs that haven't even been sung yet. 

  The list would include:
Alcohol:  I'm sure there's numerous getting drunk songs on the market
Marijuana:  Again, consult a variety of hippie songs
Cocaine:  Grateful Dead, "Casey Jones"
Heroin/Various Narcs:  The Wall, "Comfortably Numb"
Amphetamines:  Not sure what comes to mind
LSD:  The Beatles, "Lucy in the Sky With Diamonds"
Ketamine:  My best guess would be Marilyn Manson, "Dissociative"
Mescaline:  I'm clueless...???
DMT:  See above...???
Salvia:  See above...???
Ecstasy:  I'm sure some rave song has been written that I'm not aware of...
Ether:  See above...???
5-MeO-DMT:  See above...???
Datura:  See above...???  The closest I can think of is literary reference...
Tiletamine:  Veterinary drugs don't have many songs...
Benzos, Piperazines, GHB, and many others:  Yeah, I doubt any songs have been written about these lesser drugs...
God, putting it like that...I'm such a junkie...