Will it add to your tone? It can depending on the amp and how hard you are pushing it.
My 400 watt tube amp weighs 100 pounds. My 1600 watt SS amp weighs 7 pounds.
Hey hows it goin, I've got a Peavey Classic 400 too
________________
I've compared the tone and feel of several of my 300/400 watt tube power sections used to power my PA system...
I typically use solid state power amps for my PA, but I've experimented substituting the power-amp sections of my Mesa 400+, SVT-II (non-pro) and my Peavey Classic 400 by connecting my mixers output to the power-amps input (effects-return) of each of these bass amps.
I typically just run my bands vocals and kick drum through my PA... I noticed quite a big difference using each of these tube poweramps compared to my solid state poweramps, but byfar the biggest difference was when using my Peavey Classic 400. Even at similar volume levels, that poweramp added lots more fullness and a deeper heft to the vocals, and especially to the kick drum channel. That 8 x KT88 poweramp is one bad-a$$ hombre, it sounds and feels much deeper, its almost like I've suddenly added big subwoofers to to my PA.
(note, the eq-section/tone-knobs of all 3 of these tube powered bass amps were bypassed during all these experiments, so they weren't responsible for altering my results.)
So to sum this rather bizarre post up:
Yes, tube vs S/S poweramps can make a huge difference.
But what you like best is a matter of your personal preference.