as a person with AGP 8 and a radeon 9700, I can tell you, AGP does nothing so far.
I haven't seen one ounce of improvement in my current games.
there was no difference in my 3dmark2001 scores...
nothing.
I think it's psychological at the moment, like a big sugar pill.
everyone wants it, but it does nothing yet...