Sorry, was sleeping, other wise I would of chimed in on suggestions by now.
Yeah, that Celly Dual core is nice, its 100Mhz faster than the one I have in a spare PC in the basement.
Plus they are NICE Overclocking CPU's if you ever get into that, have yet to torture mine. Assuming your Motherboard has any OCing options in its Bios.
The old G31 chipset Mobo I had a year ago, had some basic options in it. the newer P45 chipset board my Celly E3200 is in, has quite a few though.
for that you'd want to pair it with some nice OCing minded RAM, and a Stable PSU, as well as decent aftermarket cooling other than the stock heatsink, since those Celly's don't come with much other than a Low profile version of the stock intel coolers.
But agreed on the video cards,
GTX 550 Ti, Radeon 6770, or Radeon HD 7750, the latter is the latest, and runs as well as the 6770, but at nearly half the power consumption.
and should handle Source games quite nicely. Especially since Source games have always been more ATI/AMD Biased in performance.
But for the PSU, I'd opt for this one, as it has just a tad more power:
Newegg.com - COOLER MASTER Elite 460 RS-460-PSAR-J3 460W ATX12V V2.31 Power Supply
the +12V rail puts out more wattage than the one Stroyal linked to.
Neither unit is truly a 400W unit, or even 460W. Why its listed as such is beyond me, as most Coolermaster Units are marketed as they really are.
but that "460W" one would be more suitable if you popped in a GTX 550 Ti, otherwise the one Stroyal linked would be fine for the Radeon 7750.
but for the GPU options, these are what I would look at.
same as above:
Newegg.com - HIS H775F1GD Radeon HD 7750 1GB 128-bit GDDR5 PCI Express 3.0 x16 HDCP Ready Video Card
Or this Refurb (90 day Warranty):
Newegg.com - Refurbished: EVGA SuperClocked 01G-P3-1557-RX GeForce GTX 550 Ti (Fermi) 1GB 192-bit GDDR5 PCI Express 2.0 x16 HDCP Ready SLI Support Video Card
the latter would perform a bit better than the former, but does consume almost twice as much power, but still a low powered gaming card by any means. Considering was 2 years ago, cards of this range consumed 200 or More Watts of power.
The Celeron Dual Core might bottleneck both a tad, but it shouldn't be too noticeable, since the cards are leaps and bounds over what you have now.
Hell, just about any card, even the $50 range cards today are leaps and bounds better than Intel Onboard Graphics.
But with those 2 above, you would be able to run games like BF Bad Company 2 on decent settings, Elder Scrolls Skyrim on decent settings (might lag a little in city areas where interacting with AI, due to CPU limitations), but even BF3 would run on that, though now too high of settings due to CPU, but it would run.
TF2, Portal, Portal 2, L4D2, etc, should all run pretty good on that.
I tested some games on a build with my E3200, 2GB DDR2 800MHz and a 192W Geforce GTX 260 video card, and was actually shocked at how well it ran on some Game benchmarks I ran.
not as good as my main Core i7 Gaming PC, but still quite well. Also tested my 1GB Radeon 4870, which is probably closer to that GTX 550 Ti in performance, or somewhere between it and the barely trailing 6770.
The Games I tested were ones like X3: Terran Conflict, using its Non Playable Rolling Demo.
You can watch the Rolling Demo video in HD here:
X3: Terran Conflict - Rolling Demo HD - YouTube
the demo, a Wing Commander/FreeLancer/Privateer/Elite like space sim, as the Slogan for it goes, "Trade, Fight, Build", actually renders the graphics for benchmarking, as you could expect in the full game, assuming you weren't in a heavy action area at the time, as this demo doesn't demonstrate that game in extreme situations...
but its enough to test with.
its one of those games you really need to have a lot of dedicated time to play, myself, I start it, and then play for a bit, and then its weeks, months later I get back and forget what I was doing, how to play it, etc LOL.
But those GPU's are ones you could easily migrate to a newer System if you built one in the next year or so.
Hmmm. Not so clear he pulled a knife after all:
The FBI has killed another person...