I ran my EVGA 8800GTS Superclocked edition with an athlon 6000 (power hog) on a 400w psu, it cranked out the heat, but after 5 months, never had any issues with it at all.
So, I could see you realistically running a 9800GT as the highest, with todays games that's going to give you some very decent performance.