i have the Radeon 9600 Pro.. bought it for 130$ Canadian.. so USD prolly a lil less than 100 (hence the 9800 pro is 120USD) it has 400clock, 600 on memory, both 128bit bandwidth on VPU n Memory..
plays all those games very well (just dont use 6x AA and over 1280x1024 resolutions)
i actually just got BF2 n was playing it at all high settings (cept resolution, set it at 800x600) and the card was fine.. it was my CPU n Ram that was sufferign the most.. the CPU light was on steady (it wasnt blinking constantly, but it was stead on most of the time lol) and my ram got eaten up in no time that my virtual memory even got maxxed.. so im guessing the card plays it fine
as for CS, half life 2, its a good card for them... sims 2.. duno.. i dont have that game..
well good luck choosin