From Black Sabbath to Metallica’s Cliff Burton, these excellent gigs also proved to be bittersweet goodbyes