I don't think the tube vice solid state is an either or. The amp is just one link in the tone chain.
I'm not a metal player, or enthusiast, I play and listen to jazz. Kenny Burelll is known for his tone, and I've seen him live with several different amps. Oddly enough, I couldn't hear the difference. I'm assuming because so much of his tone comes from his archtop and from his attack.
I have a blackface Fender Deluxe Reverb, with an Eminence speaker, a Yamaha g100 solid state amp, and a cheapo Kustom 16R practice amp. I like the Fender tone, but the tubes are shot and the amp needs some tlc. I've been looking around at new amps and here's what I think of the tube v. ss choices:
Tubes Pro:
Plenty of amps with the tones I like (jazz, remember). Mesa, Victorria, Ampeg, Fender, Peavey, etc.
Most of the players I like are using tubes, with the exception of Mike Stern, Jimmy Bruno, and a couple of others.
Tubes Con:
Fragile.
Heavy. Sure, in the suburbs you might only go from parking lot to the gig. But, in the city, you might have to ride the bus or take a cab. I used to play with a stand-up base player in San Francisco and on the bus he was no man's friend.
Hassle. Do I really want to change my tubes every couple of years. Is anyone else unhappy with the choice of Russian, Chinese, or NOS tubes? Where the heck should I buy the tubes?
SS Pros
Lighter.
Reliable.
No warmup.
SS Con:
Lot's of ss amps sound like hell.
The ss amps I do like have twenty bazillion modeling options, which someone might like, but I'd never use.
At the end of the day, I'll probably keep my Fender. When my kids get big enough for me to get back out, I'll buy (or build!) a small ss amp. Probably a Polytone, Evans, or a Tech21.
Audio equipment in general, and especially guitar amps, are surrounded by myth and legend. I do believe that tubes are over hyped, but that has driven the amp makers to produce more tube amps in response to the hype. I don't really think I've helped you make a choice.