Some of my favorite drug & booze songs are:

I Got Loaded -- Peppermint Harris

The Man from Harlem -- Cab Calloway

Save the Roach for Me -- Buck Washington

Let Me Go Home, Whiskey -- Amos Milburn (written by Shifty Henry)

Light Up -- Buster Bailey (contains the immortal line "You'll find what I'm talkin' 'bout in any ol' field")

Who Put the Benzedrine in Mrs. Murphy's Ovaltine? -- Harry "the Hipster" Gibson (a white boy, whaddaya know)