^ If you are not in hurry to buy the PC right now, I would suggest you wait for a month...intel will be launching newer CPUs, newer mobos, that have SLI certification as well...so they are better buys for you rather than the older LGA 775 socket ones...
I have yet to see any review, good or bad, on the newest Rosewill PSUs. Given that they are 80+ certified, they had to pass testing at 100% load, so I am optimistic that they will turn out to not be garbage. Maybe they found a decent OEM and can put their reputation for crap behind them.
Funny you say you're not a gamer, then list three games you want to play. Check out the "green" versions of the 9600GT and 9800GT. They don't need a power connector, but should be a lot stronger than the 9500GT.
The 9500GT 1GB is a waste of money, just get the 512MB version. I'd suggest a 4650 DDR3, but since you're set on nVidia that's not an option. +1 for the comments about nVidia boards, extra cooling, and Rosewill PSUs. Get an Antec Earthwatts 430W and you'll be good. If you're not gaming that much or doing CPU-intensive apps (video encoding, etc) then there's no reason to get an E8400, an E5300, E6300 or E7400 is more than enough for everyday use. Your overall system looks decent, but the bang/buck is not there for you usage (or at least my perception of your usage).
I don't think you'll need to worry about Crossfire or SLI; not for the games you're playing. A single, reasonably powerful card will let you play your games, and most others. For ATI, look at a 4850 or 4870; for nVidia you'd be looking at a 9800GTX or a 260. The Antec PSU can handle any of those.