Tempname :
A Core2Quad won't be a significant enough performance boost to warrant the trouble OR the money. You're looking at a 300% performance boost on the CPU front if you go for a haswell, so take that into consideration.
Of course if you can find a Core2Quad for 50USD, which you probably can't, it's a whole different thing, but I'd say you can't justify the money you're gonna spend on upgrading that machine. Better buy a new motherboard, RAM and CPU.
Obviously a Core processor is better that C2Q but would require whole unit to be scrapped, mobo, ram, cpu and possibly PSU.
I do have C2Q on one of my casual gaming rig paired with 7850 and if its overclocked a bit its fine for most of the games I'm playing in very decent detail levels. Obviously there are far faster solutions but there major con is that it would require quite some amount of cash to be spend, which i don't want to loose as long as its not necessary.
As you can see HD7750 ain't high end card anyways so putting a superb CPU without a GPU swap is an overkill... or at least not optimal.
So again it ain't perfect solution but its cheapest I could came with.
And i don't agree quad core isn't significant boost... almost every game for the last few years is utilizing 2+ cores... so theoretically putting 2 more cores to the current setup will give very visible results. I had this situation before with C2 E8400 vs Q8400, besides the quad is actually slower per core it gives quite huge kick. I can now just set affinity from 4 to 2 and see how bad i would end up. For example in BF3 from stable 60 fps with vsync on tweaked detail level @ 1080p it drops t almost 30 which is half...
So i'm sustaining previous answer if you just want decent and cheap upgrade, C2Q is the answer... if that kind of upgrade is still to not enough then an new build is required as far as you wallet is deep.