FreedomWings: I don't know what you are getting at with SC 2. What did it not?
The developers didn't give a shit about performance, hence some of the design decisions like not having LAN play and not designing a game that's multicore friendly. Also, they limited the number of units that you can use. They did that in the original game as well, mainly because computers of the era couldn't handle large numbers of units.
FreedomWings: I don't know what you are talking about with "serial in nature", but any sort of application will benefit from more cores.
Some of the most CPU heavy games are FPS Unreal Tournament 3 is relatively CPU heavy and I have been tolled it will use 6 cores and maybe even more. Oblivion and skyrim desperately need more than the 1 core they use. Crysis series is very CPU heavy as is Far Cry series, Arma 3, etc. Jeez while I was tweaking source engine games I read old post from when that engine was new about games on it being CPU heavy. Thanks to some modern games using multiple core my system easily send the frame rate through the roof. I can run many Unreal Engine 3 games very well at hundreds of frames per second which I greatly appreciate.
Traditionally cores have been used for specific things one core for animation, one core for game logic and physics, one core for graphics, etc. Tim Sweeney was talking about this when asked about the development of Unreal Engine 4.
No one said multi threading was easy, dynamic multithreading is even harder.
You can use more cores for FPS games, but it's not usually necessary. The main benefit there is that you can have more powerful AI, but I haven't seen any games where they really made much use of that.
Graphics and physics are GPU based these days. And you can get away with one for game logic for FPS games, but good luck with that if you've got millions of units all path finding at the same time.
The point is that FPS games just do not benefit the way that some other games do from a large number of cores. What you need is a smaller number of faster cores as most of what is going on needs to happen in series.