Singer and actor overcame drug addiction and homelessness to collaborate with everyone from the Rolling Stones and Metallica to Jean-Luc Godard