The behind-the-scenes fixture for six decades worked with a Who’s Who of classic rock artists, and earned 13 Grammys