If you look at every benchmark for the latest cards, PCI-E and AGP, they all come to the same conclusion - CPU limited. The available bandwidth even on the AGPx8 bus is nowhere near being utilised fully.
The only performance gains for SLI setups are at high resolutions with high AA/AF settings.
Because there are 2 cards doing the work, not because they suddenly started using lots more of the PCI-E bandwidth.
Until we get some sort of Quantum leap forwards in CPU performance, being limited by the CPU is with us for a while.
I think thats why both Intel and AMD have decided not just dual core but multi core CPUs are the way forward.
Krusty - Dunno where you heard that.
Just ordered my AMD64 dual core (X2 4400), be here this week. Fits into my current mobo with a BIOS update to recognize it. (already done).
You may be thinking of a dual CPU/dual core socket 939 board that I haven't heard about yet.
Dual core X2 ONLY ever intended for a single CPU setup, they are missing the extra pin of the Opterons to allow multiple processors.
So I can't ever see a socket 939 multi CPU board.
Current Opteron socket 940 multi CPU boards can take the dual core Opterons though. In fact AMD showed off a 4 way dual core setup (8 cores) way back in January.
Current predictions are quad cores in 2007. (new socket though

)