The C2Q are dead, DDR2 is dead and OCZ is known for bad sticks, that WD is extremely slow, and both GPUs are dying tech.
Really, about the only thing that's at least decent in that list is the new PSU.
A mid range gaming build would be in the $900-$1,200 range. That would get you at least AMD's X4 955 (possibly the i5-750) and at least an HD 5870. A high end build would be in the $1,200+ range, have the i5-750 (possibly the i7-930) and definitely be sporting the HD 5970.
I would classify this build as below budget. There are builds that cost under $600 that would be better gaming machines (the X3 440 and HD 5770).
EDIT: Sorry if that sounds mean, but the truth hurts. You probably should have just gone ahead with a new build instead of upgrading dead tech...