Well I just installed my new video card. Its a Nvidia 8800 GT with 512 MB of RAM and its "super clocked". I just ran Doom 3 maxed out, HL2:EP2 maxed out. All my games are able to be maxed out at 1280x1024 res and its not even really slowing down the 8800 or my 2.2Ghz processor.
So anyways I plan on getting Call Of Duty 4 and Mass Effect.
BTW my old card is built in Geforce 6100. Its sort of like going from a 1950's ford car to a new 2008 ford. Oh the new PSU is 500 watts and I needed a new one so I could get a PCI Express power cord (For the video card) also the video card is pretty long but it fit into my gateway.