The Rock & Roll Hall of Famer has had quite a career as a session player, band member and solo artist