It would depend on what resolution you want to play at. A 9600GT will be good for any resolution upto 1440x900. Beyond that, you would want to go for the HD 4850 or 9800GTX.
Your PSU will also matter, since more powerful cards usually suck more power.