Well for photoshop, the intel i7 definitely has the advantage here. Adobe photoshop just seems to run faster on Intel architectures than on AMD's Phenom II. But when it comes to gaming, there's not much difference here, and therefore it would be convenient to go with the Phenom II in order to save extra bills while not sacrificing gaming performance...it all comes down to how much photoshop you are going to be doing...and don't worry, going with any quad core cpu is going to last you a long time...
as for ram, you could go ddr3 on either platform but with the Phenom, you could go for the cheaper ddr2 ram...I'm not quite sure what benefits would come from going ddr3 using Photoshop...
My knowledge is restricted mainly to Intel, but I agree with Ahslan, the i7 is great with photoshop, and it'll run games beautifully too. You'll pay a little more for it, but if you're smart about your purchases, you won't be in the market to upgrade for a while.
You didn't mention whether or not you wanted Crossfire or SLI support, or if you have plans to overclock. Stock CPU coolers are sufficient in most situations when not overclocking, so I wouldn't worry about an aftermarket cooler if you don't want to overclock right off the bat. (i7's overclock very well though, so I'd recommend it a year or two down the line when it starts to show it's age; it'll come right back to life again)
Based on what I assume you're looking for I recommend the following:
i7 920 ASUS P6T SE Corsair XMS3 3x2GB DDR3 1333 RAM (This is the stuff I put in my PC, by no means is it necessary to get this particular RAM, but most brands of RAM are priced very similar, so you could probably save $10 or so by getting something cheaper. I just trust Corsair and these are nice sticks.)
Everything else you already have looks solid, and you'll have yourself a great machine.
well looking at benchmarks, the core i7 920 seems to be about 7% faster than the Phenom II 940 in Photoshop CS3...if you think that 7% is worth $200, then go with the i7...otherwise, go for the phenom...
i gotta read up on RAID..so basically it's good to have 2 hd now?
Oh hell yes. lol
The more HDD's, the better... I'm a big supporter of RAID.
Do some homework on RAID if you have the time. The 3 most common RAID #'s are: 0 for speed, 1 for identical twin drives, and 5 which is essentially a combination of 0 and 1... it's complicated to explain here; I suggest wikipedia or other internet sources. RAID 0 and 1 only require 2 drives, but RAID 5 and most others require at least 3.
I would go with 4gigs rather than 6gigs...im a big fan of Gskill ram...
As for raid, Ive never set up my personal rig to use it, but we do use raid 1 at work so that files are backed up on the identical drive, just in case something happens to one of the drives...