I am going to have to stick with this one (Intel Core2Quad Q8300 2.5) because it is all I can afford even though I am getting a computer custom build for me
here are the specs if I get the custom computer made
-550W Heavy Duty TOUGH Series SATA Power Supply
-MSI G41M-P35 Intel G41 DDR3 Audio Video GB LAN
-6GB (3X2GB) DDR3-1333 PC3-10666
-Intel Core2Quad Q8300 2.5
-LG 22X DVD+/-RW SATA (DVD drive)
Ok let's sort it out...
550W thats to much so you can save some money if you buy 450-500W like i said. 450W good quality PSU is better than 450W off-brand PSU, this is how it works....
MSI G41M-P35 Intel G41.. well this is Mboard with fused Graphic Card, basically not good, MSI ahve great mboards but try to find something without graphic card marged with Mboard. Maybe other model from MSI or even Gigabyte.
6GB of ram is to much, 4GB it is MAX which any game will be ever able to use, so save some moany and buy 2x 2GB

As for processor, yea it should work.
YOu are buying this PC from some online shop? If yes then link site, maybe we can help you build something better even if you are short on money. Ohh and tell me how much MAX. money you want to spend on this PC.
It is on ebay and the seller lets you edit it to your liking so here is the link http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&item=150606908089&category=179&_trksid=p5197.c0.m619
my Limit is around $400-$450 maybe just a little higher but it depends