It's probably some kind of commentary on human nature that a fair number of great songs have been written about drugs. They range from cautionary tales like Ed Sheerin's The A-Team, to frank love songs like this classic Grace Slick/Jefferson Airplane performance at my 26th birthday party.
A recent chart topper is The Weekend's paean to cocaine, I can't feel my face.
I hate drugs, but I love the music. I feel the same way about Wagner.