This belongs in Software, but
Dual core / SMP:
In general the second core allows the CPU to perform as if it were a 10% faster single-core, for example a 2 GHz X2 A64 runs like a 2.2 GHz single core A64.
Dual-core optimized games (Quake 4, Oblivion) only really offer a benefit for the slowest dual-core CPUs (P4 805D and to a much lesser extent X2 3800+) to help make up for their lower per-core speed.
With faster dual-core CPUs there is little or no benefit in real-world use, the only gains are in silly benchmarks like running at 800x600.
No games out now use the second core for making major improvements to AI or physics, and the GPU is the bottleneck for most other parts of a game.
Windows 64 native games:
As far as I know there hasn't been any real benefit. Most of the benefit from 64-bitness is for server and workstation applications that need to access more than 4 GB of RAM.