I just recently bought a new AGP Nvidia 7600GS and it has been working really nice. Runs pretty much everything on max settings smoothly and relatively cheap as well. Got mine for about $120 off of pricewatch.com. It’s one of the better cards out there for AGP. Almost anything better would be PCI-e.
Just incase you were interested, even though you said you were a poor shmoe.