The video card you want to purchase will depend on several things.
1. What games do you want to play? Google the game name + review to see what cards work well with the games you want to play. You might also type in the graphics card, or check Graphics Card (GPU) charts. Also be aware of what resolution you want to play at. A standard 19" monitor will require less powerful of a card than a 30" monitor will.
2. What are your future upgrade plans? You may choose to buy a drastically over powered card for your system with the intent of upgrading your processor or system in the near future. An example of this might be a new mid ranged card that will become cheaper over time. If for some reason you would choose to (or be required to) replace your motherboard, you might consider getting an SLI or crossfire board and buying an identical (same chip) card for a nice cheap upgrade. Other reason to replace a motherboard in your system include: a good deal on a motherboard with a superior north bridge, perhaps you want to try your hand at overclocking, or maybe you need more PCI slots.
3. Budget. Mid to lower-mid ranged cards are generally the best value due to economies of scale and due to the fact that high end chips can have non-working caches disabled, which salvages the chip and makes it sell-able again.
4. Power supply requirements for chosen card. As mentioned, you may need to upgrade yours. A cheap PSU is no laughing matter. A dying one can fry your system. You don't want to purchase a new PSU that is vastly over powered (i.e. a 1000w PSU for an ATI 4670 GPU) as it will cost you a bundle on your electric bill. Nor do you want to underpower your card as it will result in black screens and reboots when the card is overtaxed and needs more power. If you're not sure how much power you need, check the card specs. Most basic systems don't require more than 500w. What is more important is how steady they can output voltage, and how quiet they are. Do your online research to find the right PSU for your needs. Choose your card first, the PSU you purchase should be matched to your system. People rarely pull all the parts out of a completed system so you probably won't be using your PSU in another build. Why scrap a perfectly good PC right?