But surely you'll have a hell of a lot less CPU power than, say, 128 of Linode's 512mb virtual servers, meaning they would have much worse performance if fully used?
The hyper-threading technology is a pretty cheap way to add more virtual cores to your VPS's which is great. One thing is for sure and that is that Linode provides you 4 virtual cores and not 12 per VPS. But, that of course doesn't mean their CPU is better or worse. But, if you can run 6 cores at 3.8ghz, or 12 cores at 1.9ghz then I wouldn't worry too much about not having enough CPU power for your virtual private servers.
If your typical load is actually at 100% CPU for the majority of the time, I'll go out on a limb and suggest that VPS might not be the best bet anyway.