Any thoughts on this VPS Host?

Number of CPU cores doesn't matter since SRCDS is a single-core application. Sometimes, but only sometimes, it takes another core just to do the networking stuff.
What you really need is clock and FSB speed.