This is changing now, with the new consoles out the big AAA cross-platform game engines will restructure themselves to use 8 cores, as that's what both the XBOne and the PS4 have.
This is an interesting point. So far, there has been little to no reason for most users to get anything more than a quad core; so few things really use more than a couple of cores at any intensity. But games written for the current crop of 8-core consoles will *eventually* start getting PC ports, and in general the whole toolchain for doing multiple core computing will improve under market pressure from studios and developers. If you replace your computer every couple of years, this probably isn't a worry yet; if you're expecting things to last 5+ years it's probably something to consider.
If I had to guess, we're drifting toward quad-core for mobile and embedded, oct-core for desktop and console as the default for power users and gamers. I suspect there will be a plateau there for a bit, but we'll see.
To bring this back to DF, as others have said anything but the tiniest embarks on the slowest CPUs are likely I/O bound; the limiting factor seems to be getting the data (gigabytes, far more than any cache) from main memory to the CPU and back again, every frame. This is rare for games *or* benchmarks, which makes comparisons difficult. Single-core performance is the next most important factor. In general, more recent Intel CPUs and chipsets tend to be on the top end, but if you're on a strict budget may not be your best price/performance choice down lower.