I think the reason you like Spitfire stuff so much is that it sounds great right out of the box. There's no question about that. If you used nothing but Spitfire products, you'd never have to worry about getting a good sound. If, on the other hand, you want to mix and match sample libraries, you may find that those great out of the box libraries become a problem. That's my experience, anyway.
Hyperion is a dry library. Dry libraries tend to sound raw and harsh and, as a result, unnatural to a lot of people. People have the same complaint about LASS string libraries. With Hyperion, I find it helps to tame some of that harshness with a low pass filter and a bit of EQ. Fortunately, the library comes with EQ built into the GUI, so they make it easy for you. You can play with the "Body" dial, the EQ dials and find a sound that's more pleasing to you. Add some of the built-in reverb to create some space and distance, then use a bus on the track and send it to another reverb.
The reason I like Hyperion is because a) it's dry; b) that makes it easier to manipulate; c) the sounds are easily customizable to individual taste; d) the price is outrageously low for what you get; and e) it can be layered with those Spitfire and other bake-in ambience libraries to give them a rawer, more real presence.
I get the sentiment, but really it isn't that hard to whip these libraries into shape. I think of libraries like Hyperion as raw material to be bent to my will. Fortunately, it's very bendable....