Well, that i3 is good enough to handle HD 6950, so there's exactly no need to upgrade.
So, my suggestion is to save up for Haswell, which is coming next year.
To answer your 2nd question, games do use quad/hex core CPUs. The correct question should be "When will games be able to take full-advantage of more than 2 cores?"
The Ans. God only knows.