I think pretty much all newer games are now quad- (or more) core aware.
When I had it, my old dual-socket (quad-core) HP xw6400 with 4gb and a nVidia 275 played pretty much any game from the 360/PS3 era without issue, at highest or near-highest settings
(yes, even Crysis).
The new generation of consoles makes it now a bit out of date, but the fact that a 2006 (yes!) machine with a mid-range 2009 graphics card can do this just shows how consoles hold game development back...