Your card is not DX-9 enabled. Be sure to get a card that is. All the Nvidia FX cards and ATI 9600/9800 are DX-9.
There is a big range of cards between $100 at the low end and $200 at the top.
My votes on chipsets:
Low end: A FX-5200 Ultra or FX-5700 LE. I wouldn't normally advise any card that ends in LE or SE, but the 5700 LE is different. It can be overclocked to 5700 Ultra performance. You'll need the coolbits registry change to enable the built-in Nvidia overclocking sliders.
In the middle at $150: the ATI Radeon 9600 XT or a FX-5700 Ultra.
At the $200 end: ATI Radeon 9800 Pro.
Note these are chipsets, not necessarily ATI branded cars. Go to Newegg.com, click on Computer Hardware tab, then the Shop By Category, then Video Cards. Use the search tool on the left to choose the chipsets.
A few folks are having problems with ATI chipsetsin AHII. Others report they work great.