ATI RADEON® X800 PRO, (256 MB) AGP Video Card

Pros: AMAZINGLY fast and powerful; low power requirements; one slot; easy setup; Half-Life 2 = amazing!
Cons: Expensive, but you get stellar performance; craves CPU power; no Half-Life 2 ticket

When I got my Dell system two years ago, my graphics card was mid grade, but it still pulled off some amazing things. But now, being two years later, my Geforce MX410 was getting a little tired. And since I want to run everything so it looks all nice and ...

Pros: Great performance for current games.
Cons: Not the best value card currently. Future games will run poorly on this.

... it's starting showing its age with newer games. Originally I bought this card for Half-Life 2 and I was definitely satisfied with the performance. I have a Pentium 4 3.0 GHz with 1.5 GB of DDR400 memory and I was basically able to play Half-Life 2 ...

Pros: ok performance
Cons: price

It's a good video card for the money and for the older games but it is not recomended for new games like BF2 it doesn't well like nvidia 6600gt which is $100 less.

Pros: Beautiful performance, one of the best you can get for AGP.
Cons: Retail price is expensive, and won't run the next-gen games at max.

I'll keep this one fairly short, as I'm not going into anything particularly technical (aside from pointing out that this is a 400mhz GPU... higher end ones usually don't break 500 or 550, and a step lower runs below 300mhz typically, so this is extremely competitive)
Here's my experiences, though, with my gaming PC (3ghz processor, 1GB DDR 400 ram, and this video card):

Doom 3: maxed out settings (at 1024*768), it rarely visibly stuttered. And it looked GREAT. Setting the resolution higher lowered performance slightly, but it wasn't really an option for me (small screen), and 1024 is a good gaming resolution anyway.

Half-Life 2: I ran the auto-detect... and it maxed everything out. Also great looking. On the "Lost Coast" bonus, and Episode 1, which requires more power than the normal HL2, it stays high framerate consistently, with the only effective stutter at the very beginning of a large outdoor level. It clears up quickly, and then runs smoothly, even looking out over the entire area. Wonderful.
update:
Half-Life 2: Episodes 1 and 2:
Beautiful. Everything stays maxed out all the time on my system, and framerate is almost always transparently fluid, even in fast-n-furious gunfights.

Pros: amazing performance, doesn't heat easily, runs anything you have maxed out.
Cons: price \:

great card. Has never overheated on me after some solid half days of gaming. Runs Half Life 2 and Counter Strike Source maxed at around 60 fps. Runs Battlefield 2 online perfectly all maxed out. Fear, maxed out. Doom 3, maxed out. great card

Pros: Frame Rate, power, speed, versatility
Cons: Price

This graphics card cranks out the maximum frame rate on almost ever game i can throw at it. Doom 3, is a solid and consistent 60 frames a second with EVERYTHING turned to the max. This card has so much power behind it its almost scary. At $400 your going to feel this in the wallet, but for me at least; I can't put a price on being able to play D3 and HL2 with out glitching.

Pros: High frame rates, low power consumption, one slot, runs cool
Cons: should have the card in deep blue to match my system =)

Radeon X800 PRO model is just slightly slower then the X800 XT but the difference in speed is very hard to see. I am a pc enthusiast and i have always been with Nvidia, until the day i purchased the X800 pro. I run games such FARCRY, GENERALS ZERO HOUR, HALO, DOOM 3 on very high modes and the frame rates hit over the vsync all the time. Smooth graphics performance, low power consumption. ATI thinks of a hardcore enthusiast, they do understand that we cannot have 800 watt power supply just to run their video cards. Chances are if your spending the money on a 400 dollar video card you will not want to be buying extra power supplies. Besides The GeForce ULTRA 6800 was beaten in some tests by THE X800 PRO model, which is cheaper and consumes less power.