You need at least (IMO) an i7 cpu series to run those new games without any problem. Your Motherboard is also a bit old so I don't think it supports that CPU.
The i5 2500k is currently the defacto standard that most people recommend (the 3750k Ivy Bridge is around the same ballpark as the 2500k but if you have a dedicated GPU already, you won't notice much improvement at all). The most important piece of hardware for gaming is the GPU, not the CPU.
You will need a motherboard that has an LGA 1155 socket to perform this CPU upgrade.
[Edited by Neo7, 11/22/2012 10:14:19 AM]