That's what I have. I use the BFG 8800 GTS 320MB version that was reviewed here a couple of weeks ago. I can actually play Oblivion and Rainbow 6 Vegas with all settings maxed out while encoding a DVD at the same time and it's smooth as silk. I have never tried it on Vista though. Just XP Sp2...
I can't speak to the quality of Rosewill PSU's (although that exact model is recommended on Anandtech's current buyer's guide list) but I do agree with the poster who said that power supply wattage for video cards is highly overrated these days. What you have should be more than enough to power...
8800's? 1000 watt? Holy cow! I've never had trouble running my 8800 at max-res on a 450watter... and that's including 2 hard-drives, 2 DVD-R drives and a few case fans.