I think diabloII was being a little generous with the PSU. You would be able to do fine with a 350W. Although, 480W would leave room for future upgrades.
BF1942 doesnt need that fancy of a vid card. I played it on my 9200, and on my bro's comp with onboard video, with decent settings. HL2 on the other hand needs a little more power. If you got a 6600GT, you would be able to play games at good settings.
BTW, diabloII, holy piss, when did your post count get so high. I swear you werent much higher than me like 3 days ago:amazed:
Intel E6750...........PSN: ELBATROP
XFX nForce 650i Ultra
Patriot PC2-6400 8GB (4x2GB)
36GB WD Raptor
Samsung SyncMaster 931c
Samsung SyncMaster 750s
Windows 7 Home Premium 64