I think this is a case of "we're all right, but we're not talking about the same thing"
The Articia S isn't that bad on memory access. It's using SDR, after all. I've seen worse.
A G4 can't utilize DDR, because it's got a 133MHz FSB.
However, two G4 CPUs and an AGP card and a couple of PCI cards could very well manage to fill up the available bandwidth without much trouble. But you would surely need a DDR, AGP4x, PCI-X and dual CPU-capable northbridge. Where can you get that for PPC, I hear you say. Well, we're kinda waiting for MAI to get the Articia P released, and it has all this. I was going to write that it's too bad Motorola doesn't support 166MHz bus, but it seems from an article about the 970 I just read that Macs are sold with 167MHz FSB, so I dropped that. If this is indeed correct, you could see an Amiga using single G3/G4 or dual G4 processorswith AGP4x, PCI-X and PC2700 memory. It all boils down to MAI getting some wheels in motion, I guess... Hopefully they've managed to get a lot of the fixes done to the Articia S into the P.
Now, where does the 970 fit in? It doesn't, I'm afraid. It uses two 900MHz 32bit front side busses (one for reads and one for writes), and this needs a rather special northbridge. I have yet to see anyone claim to support this yet. I wish IBM was more like Intel in this regard. New CPU -> New chipset released same time. At least IBM are going to base their own Blade servers on the 970, so they must support it. But you don't need AGP on a Blade (but DDR memory and PCI-X for GigE is crucial). I don't know if anyone will start using PCI-X for graphics. Could be a useable solution...