@ Red
My friend has An athlon 2800 1GB ram and radeon 9800 pro 128MB. It copes plays Quake 4 smoothly at 640*480.
I'd recommend getting a Geforce 6600 GT as these are more powerful than the Radeon 9800, unless of course you can get a deal on something faster. From what I've heard an AGP 7600 won't necessarily mean better performance than the 6600 Gt