I think most games actually don’t need more than one or two cores. In many cases one would probably be enough but since the OS requires some resources as well a second one might be a good idea.
Most of what games give you is eye candy on top of more or less simple game mechanics, and making eye candy is in almost all cases the job of the GPU. The actual game logic is often very primitive. For example the game logic of Star Craft 2 is not much different from Star Craft 1. So if Star Craft 1 ran on machines from the 90s (is that right? I am not sure) then a modern CPU can do that stuff easily.
The only cases I can think of where the CPU might be critical are very simulation heavy games with large amounts of physics or maybe some sort of complex economic simulation. Maybe a very complex AI system can also make good use of some additional CPU power.