Good is subjective, but here is a list:

Billy Strings: Dust in a Baggy - Heartbeat of America (LSD)

Peter Tosh - Legalize it

Tyler Childers - Nose on the grindstone

Peeping Tom - Mojo

George Thorogood and the Destroyers - One Bourbon, One Scotch, One Beer (John Lee Hooker Cover, original is good too)

J.J. Cale - Cocaine (Also covered by Clapton)

Kris Kristofferson: Billy Dee - From the bottle to the bottom

Mr. Bungle - Goodbye sober day

Devil Makes Three: Old Number 7 (Alcohol) - Champagne and Reefer -I gotta get drunk

NWA: Dope Man - 8-Ball

Sublime: (Lots of Sublime) - Smoke two joints. 40oz of freedom.(Alcohol) - Legal Dub - Let’s go get stoned.(only referenced in name) - Scarlet Begonias - Waiting for bud (only references in name) - Pool Shark

NIN: Hurt(Heroin) - The Perfect Drug

Willie Nelson: Roll me up and smoke me when I die.

Amy Winehouse - Rehab (Alcohol)

Rick James - Mary Jane

Red Hot Chili Peppers - Under the Bridge (heroin)

Tom Petty - Last Dance With Maryjane

Technohead - I want to be a hippy (Good is subjective here, Happy Hardcore)

Warren Zevon - Carmelita (Heroin)

And many many more, but I have shit to do.