I remember when AGP came out and it was advertised as making it possible to store textures in RAM, requiring your GPU to only have enough VRAM to act as a cache and frame buffer.

It quickly became apparent that AGP, even as AGP 8x became a thing, wasn't fast enough to do the job, as every GPU still had tons of VRAM.