He went from the towering highs of the 60s and 70s, where he changed the face of music, to the shambolic lows of a decades-long addiction. But interviewing the music genius over the years showed me a man who was awed, revered and strangely shy