In my experience most modern games the difference between AGP 2X to AGP 4X tends to be roughly 0-6% in my experience, with a slight trend towards the lower half of that.
I don't see the design of consumer 3D rendering/gaming applications changing enough within the next year or so to dramatically change that profile, so for the immediate future I don't believe AGP 8X to be much more then a chckbox feature for OEM's to hype.
Beyond that we will be hitting the crest of a few newish technologies which will gradually become maintream and could potentially influence the impact of AGP transfers, so it's difficult to guess what we may see in 1.5-2 years.
In the Pro3D market I do definitely see it as potentially impacting performance to some degree almost immediately. We've already seen that high edn Pro 3D boards can see upwards of 12-17% boosts in performance from AGP 4X over AGP 2X. The improvement to AGP 8X will almost surely see diminishing improvements, but it'll likely be appreciable nonetheless.
Nonetheless, such improvements are still quite unusual in most applications and primarily relegated to the high end Pro3D hardware, the mid-range boards up to about $1000-1200 likely won't be put in a position in which they would see such benefits.