Pentium 4 had an exceptionally long pipeline to be able to hit higher frequencies, trading-off high IPC numbers in the process, most of the time. On top of that, Pentium 4 also “looped” the same instruction while waiting data resulting in lower efficiency and higher heat output.
So, I assume, they are “step by step” comparable. i.e. slowest P4 equal to slowest G3 and they are again equal at next stepping and so on.
It actually was between PIII and IV on capabilities. Altivec allows to play h264 videos on
some settings. A Pentium III, well, SSE and FFMPEG can do magic, but not
as well as Altivec. SSE2 it's better, much better. Basically the minimum for x86
and 'modern' browsers.
On the architecture itself, PowerPC did far more per cycle.
Surprisingly enough the N64 used RDRAM (and supported a memory upgrade, lowering the cost of the console at launch but enabling an upgrade path for games that needed more memory.)
I recall folks claiming the G5 outperformed Pentium D, but I had both and not only was the Pentium snappier, "Roxio Toast" could burn a DVD in half the amount of time on it.
Maybe it was a software optimization issue and Toast just didn't use Altivec, but I was not surprised at all when Apple moved to Intel.
it was mostly marketing "oooh altivec can do sooo many FP calculations that it has to be licensed as a deadly weapon". Same kinda marketing for MMX "if a programmer was an a MMX guru then basically you have a supercomputer bro"
That's all great but it was all awaiting a killer app to make it all worth it and reasonable, versus random programs rarely supporting it for a little boost.
And the name of that killer app, using these DSP type features? Local AI.