The X1950 XT - manufactured exclusively by Gecube - is simply the most powerful card ever to grace the AGP bus. This card's closest competition is the XFX 7950 GT, which costs slightly more but is a lot less powerful.
At $235, it is a bit of a tough pill to swallow for a dying interface. I would only recommend the X1950 XT AGP to someone with a very fast AGP system who already has a power supply with enough juice to handle the X1950 XT.
It must be noted that if you have $235 to spend on an AGP card - and possibly an extra $100 for a power supply that can handle it - you may be much better off purchasing a PCI Express motherboard, CPU and PCIe graphics card.
PCIe graphics cards are cheaper than their AGP cousins. If you upgrade your system to PCIe and sell your old components, you may actually spend a similar amount of money compared to buying an expensive AGP card alone.