From once-in-a-generation talents to hair metal heavy hitters, here are some of the biggest unsung heroes of the guitar world whose time in the spotlight was all too brief