I honestly don't know what you have against nVidia. It may have just been 1 specific card you have, but that certainly does not justify calling all nVidia cards bad. That's like going into a particular McDonalds that is very dirty, and then saying that all McDonalds are dirty.
I have owned 4 nVidia cards (all for AT LEAST 2 years) and I have never had a single card burn out, short circuit, die, etc.
Anyways bkieft, the 7800GS is a really nice card. It doesn't really live up to the 7-series name, but on AGP, it's really one of the top cards you can get.
IMO $300 is "crazy expensive", I would have recommended a 6600GT or 6800GS (especially since your rig is AGP and will die out soon), but hey, if you're happy, that's good for you.