All the new games are going to see an increase in Dual Core, Oblivion already does see quite an increase when you run Dual Core.
And yea unless your on a tight budget, the C2D are quite a bit better after overclock. Stock for the money they are very close but still the C2D is better at most things.