TalonX it really depends on the capability of your PC, (ie: AGP or no AGP slot and 4x or 8x capable speed). Once you determine whether or not your capable of running an AGP style card with 4x or 8x speed then it comes down to cash. If you can't afford or don't want to spend alot of money there are some decent cards out there. Everyone seems to have their own opinion on which cards to run.
I've ran both ATI and NVidia chipsets in my computer. Originally I was running a Ge Force 4 Ti 4600. It was a great card till the fan went out on it. I tried to replace it but in the process messed up the GPU. Overall it was an awesome card. No issues with it all on any games I played with high resolution and fairly maxed out graphics.
I'm currently running the 9800XT by ATI. It's a great card in my opinion. I've never had any issues with it other than the fact if your house is fairly warm you could have some cooling issues. The card generates alot of heat and coupled with the other heat being generated throughout the case it can be a pain to deal with. I'm running a Thermaltake case with 8 case fans in it and it still gets warm inside. You need a fairly decent power supply for this one though since it's very power hungry.
I'd stay away from MX series cards by NVidia. They are good to an extent but really not worth the money for the product your getting and for whatelse is available on the market. What you really need to do is research the cards capabilities. Many sites have card comparisons. From there you can get a decent overall look at what your getting. Far too many folks make the mistake of buying a card that isn't really as capable as they'd expect. I myself avoid that whole inbetween comparison fiasco and just go with the top of the line card at the time I want to upgrade. Then it's only a matter of comparing a few top of the line cards opposed to 8+ in the intermediate level category.