As others have mentioned throughout this thread, much of what you experience has to do with the system as a whole rather than a single component. There are many different designs out there and yes a tube preamp can be voiced anywhere from overly lush to extremely sterile.
Not to turn this post into an add but our Purity was designed to have the 'speed and articulation' of a solid state unit but without being sterile or dry. We were not looking for a solid state sound. If we were, we would not have designed a tube unit. We wanted to retain some of that tube nature.
It is no different with tube amplifiers. They too can be designed and voiced 100 ways to Sunday. I have always liked the warmer side of neutral presentation but over the past year or so I have come to the realization that you can have the best of both worlds...i.e; neutral yet musical.
There are tradeoffs in tube amp design like anything else. If you want a tube amp that will last for 50 years without replacing a single tube, you have to build a circuit that is "kind" to the tube. The downfall is that these designs are usually very warm sounding. A perfect test can be done by anyone who has a tube amp with manual bias. Bias the tubes at the lower end of the spectrum and you have a lusher sound, crank it to it's upper limits and you have a harder sound. The downfall to this is the tubes will not last as long. The harder you run a tube, the "harder" the sound. This is obviously not the case with every tube product (so no attacks please).
Tube rolling can change the sound slightly but to get the sound you want, look for a product that is design and voiced to provide what you're looking for. If you do not like the overall nature of a given tube product, changing tubes is not going to change it into something it was never meant to be. Tube rolling, just like cabling is good for "fine tuning". A good design should give you enjoyment and provide the traits you are looking for regardless of what tube is used. Different tubes are not band-aids, they are a subjective and personal tweak.