Consider an nvidia 6600GT or 6800. A 6800GT might be a little overkill based on the rest of your system.
If you don't want to spend what a 6600GT costs, one of the ATI 9800 series cards would be at the top of the last-generation heap. Just don't buy any "mx" or "SE" cards.