“The first thing I did in the morning was take a fix… I don’t know why I started. I suppose it was to overcome my insecurity”: He was a member of one of the most famous supergroups of the late 60s. But this forgotten great died in poverty aged just 43