For that price, it's a good card.
You will be able to play Doom3 et al with it, albeit at medium to low gfx settings.
If I had a pound (yes, a Pound) for every "LoL d00d - 9600 sux - get a 9500/9800/X800 etc" I'd be rich. 9600's are good cards for the price, and if that's what you can afford, it's a GREAT card. You'll certainly notice a great improvement over your GF2 gTS....