Drugs, drink, and debauchery reach a devastating peak—yet Sly Stone, The Rolling Stones, and Jim Morrison produce some of their best music.