I'd love to see a scalable setup:
First card can be AGP *or* PCI, doesn't really matter.
Second and up card would pretty much have to be PCI.
It would work better if it were sold as a primary/secondary setup. "Primary" card has the VGA output plugs/TV/DVI/whatever. "Secondary" card would not have outputs and would not need any SLI cables or VGA pass-throughs. Plug it in and it goes, you get 50-100% performance gain.
It can be done, the Matrox M3D card didn't require any video cables or pass-throughs, just design it to use multiple processors as they come in.
I'd love to see that.