Everyone hates that mate that cant stop talking about what he got up to when on drugs, but yet everyone loves when a band writes a song about it. Right?

My focus hear will be songs about heroin but you can pick what you want, just the lcd and mdma ones are plentiful.

Spacemen 3, Things'll Never Be the Same: https://www.youtube.com/watch?v=tAu9R_XvHPo

The Velvet Underground, Heroin: https://www.youtube.com/watch?v=qFLw26BjDZs

This one is more about depression led self destruction. Drug related or otherwise.

Black Flag, Damaged I - https://www.youtube.com/watch?v=zf6W9TMol6U

Finally a sad song about a lost friend to drug use.

Bert Jansch, The Needle of Death - https://www.youtube.com/watch?v=oA7npXJLQOU