The man who ended up smoking 30 cigars a day after trying to quit cigarettes also comes across in his book as level-headed, self-aware and savagely funny. Here’s what the late rock legend can teach us about addiction, fame and how to choose just the right support act