No wrt the 4870, any card you use needs to have a PPC compatible ROM. That basically leaves only things that either Apple or another company sold for use with the G5s.
But a good card IIRC is the GeForce 7800GTX. I am not sure how it stacks up with the Radeon X1900XTX though.
barefeats might have some benches and you can probably find some used ones for $50-$100 from PC users.
*Edit Being perfectly honest, what you want to do is a big waste of money when you could just play DOOM 3 on even a semi-modern PC and max it out.
That being said, I know how appealing maxing out an old system is so I just want to make sure you really want this before doing it.
Sure, you can flash the cards, but you need just the right one (earlier reference cards) and it is not hard to paper weight them. I suggest the x1900xtx with a different cooler. It is basically a FireGL for Macs. Some of my ATI card mods/upgrades are listed around the site.
my current card (Nvidia 6600) has 256MB and I find it sort of lacking. I also plan to be running a second display for Logic Express's mixer window, so I want as much memory for the card as possible