I don't know why they call them Intel Core 2 Quad.
The Core 2 is misleading, but the Quad says it is a quad core processor.

It will definitely play wow.
And if that's your budget, it seems a decent price for what you're getting.

I'd still recommend an i7 with ddr3 if you can afford it.
If you can go with your existing case, video card, hard drive etc.
And get the new motherboard, ram and processor.
Not sure if you'd need to upgrade your power supply etc.