=================Quad Core=====================================
Bioshock (Unreal Engine 3) - Quad core support.
Call Of Duty 4 - Ground up quad core support.
Company of Heroes - Ground up quad core support
Crysis - MP Beta Dual Core support, full game ground up Quad Core support.
DiRT - Ground up quad core support (up to 8 cores reported).
Flight Simulator X - Quad core support with patch.
Lost Planet - Ground up quad core support. (octa core support as well).
MOH: Airborn (Unreal Engine 3) - Ground up quad core support.
Supreme Commander - Ground up quad core support.
The Elder Scrolls: Oblivion - Quad core ground up, can use 5 threads.
World in Conflict - Ground up quad core support.
Unreal Tournament 3 (Unreal Engine 3) - Ground up quad core support.
http://www.pcgameshardware.com/aid,...rks-75-percent-boost-for-quad-cores/Practice/
==================Dual Core=====================================
Age of Empires 3 - Dual core support.
Call of Duty 2 with 1.01 smp patch - Dual Core support
Enemy Territory: Quake Wars - Native dual core support (possible quad, need confirmation).
EVE online - Dual core (possible quad core, need confirmation)
Falcon 4.0 - Some Support, extent unknown.
Galactic Civilizations II - Dual core support.
Gothic 3 - Dual core support.
HL2: Orangebox - Dual core support
Stalker - Dual core support with 1.0004 patch.
Quake 4 - Dual Core with patch.
Titan quest + Titan quest Immortal Throne - Dual core with patch.
World of Warcraft - Dual Core with patch.
Old list taken from
http://www.xtremesystems.org/forums/showthread.php?t=213165
More official list
http://www.grandtheftpc.com/2010/03/list-of-quad-core-optimized-games.html
Plenty more games out there. I'd say most if not all modern day valve games are also make use of Quads.