Well, the 060 is superscalar with two pipelines, so... it's probably two 50MHz pipelines.* About good as having a 100MHz CPU in the best case. In x86-land, the Pentium was the first 'iteration' of the family to have two integer units, though NexGen's Nx586 may have beaten them to the punch (I'm not sure how the releases were timed, the original Nx586 didn't *have* floating point units, and that design team was acquired by AMD, resulting in the K5 and K6-* series of processors)... Practically everything since then (for the 'desktop' market, anyway) has used the same techniques; the PPro, which begat the P-II, was the first to have it throughout the chip. (Some else will have to chime in on the PowerPC interations.) Modern chips can/have had things like 4 or more pipelines, though I don't remember the exact numbers for Athlon/Opteron/PPC970/P4 off the top of my head.
But to drag this up to the things you see discussed on ArsTechnica and the other PC sites today...
The Pentium 4 has some units that run at double clock ("Simple ALUs," apparently), but other things can still take more than one tick to execute, and thus 'drain' the pipeline, negating some of the benefit. Intel's been trying a different take than other manufacturers, going for a sort of 'waterslide' approach (I think their marketing buzzword is "Netburst," and the common description is 'long and skinny'), versus, say, having a couple sets of stairs ('short and wide'). Sounds great until some kid gets stuck halfway down. ;-)
The PPC970 seems like a bit of a compromise between extremes... When Motorola was pushing G3s and G4s, they were really 'wide' and 'short' versus the x86 lineup... so you get more instructions per clock, and more resistance to 'pipeline bubbles,' but you can also have a harder time clocking the unit up to competetive levels, since there are more units to keep in synch. In practice, it sort of evens out, and you get relatively comparable performance for the same number of transistors spent.. and processor lines 'tuned' better to one or another application. (G4 AltiVec is a big win for some things, and the rest of the chip has proved pretty decent for general-purpose computing; the P4's design has, in turn, proved pretty decent for stuff like video and audio work, where there's more math to crunch in between conditional branches, and AMD's managed to keep their stuff goodly fast all-around, usually with a price/performance advantage.)
*If you want to know the specific details of the chips, find the technical docs, or someone who actually wrote assembler for them... I just have the 'big picture' view of anyone who's spent a week reading Ars and the britnews sites.