Nikki Sixx (bassist of Motley Crue) has made a whole album about his addiction. It's called The Heroin Diaries: Soundtrack, with his other band Sixx A.M
His addiction was heroin and alcohol but there is alot about recovery and addiction in general.
Also Motley Crue has several songs about it: Kickstart my heart is a good example.
That is, if you like rock'n roll and rockmusic, haha.