The only one I can think of off-hand is Keith Richards of the Rolling Stones. I read his book a few years ago. He was a stone cold junkie, in and out of rehab for years before it finally took.
My issue with Prince tho, is the fact that he presented himself in such a spiritually enlightened way. I felt like he bamboozled us, which plays a big part in my anger towards him.