... The final Tualatin PIII-S 1400 wasn't soundly outperformed by the Pentium 4 until it reached speeds nearing 2 GHz. A dual Tualatin system could hold ground with even faster Pentium 4s that had Hyper Threading.
My experience is that my dual Pentium III-S 1.4GHz IBM x330 1RU server isn't soundly outperformed (where 'soundly outperform' means 'at least twice as fast') by ANY Pentium 4. I use the old Byte UnixBench suite for basic comparisons since it has a good mix of CPU-heavy and I/O-heavy benchmarks; the x330 gets a single-CPU score of 201.7 and a dual-CPU score of 324.6; I have several old Dell PowerEdge SC1425's with the late 64-bit capable Netburst Xeon's, which are basically Pentium 4's with lots of L2; at 3.2GHz, with HT off, I get a single-CPU score of 275.5 and a dual CPU score of 491.4 (running 64-bit code; I would expect 32-bit code to run faster by some percentage).
To 'soundly outperform' according to my definition the single-CPU score would need to be at least 403.4 or the dual-CPU would need to be at least 649.2; even the fastest NetBurst CPU made, running at 3.73GHz, probably can't touch a single-CPU score of 403.4. A dual-CPU dual-core box might be able to beat the multi-CPU score needed of 649.2, but I think upgrading to a Core 2 Duo will be required to reach the 'soundly outperform' threshold.
In contrast, a Dell PowerEdge 1950 (Core 2 Quad-derived dual Xeon E5410 @ 2.33GHz) scores 647.6 single-core, 2384.4 8-core, and my third-gen Core i7-3740QM (2.7GHz) laptop gets a single-core score of 1336.8 and an 8-core score of 4203.2. One of the major UnixBench components is Disk I/O bandwidth and latency, so multiple CPUs don't scale linearly. Also, just for grins and giggles, I ran UnixBench on an SGI Altix 350 system way back in 2012 and posted to Nekochan; this is a 30-CPU system, running 1.5GHz Itanium CPUs, and it racked up a single-CPU score of 444.0 and a multi-CPU score of 1170.6; the slow SATA drive tied to a single node really kills this system, as the single-CPU Dhrystone of 419 relative to the 30-CPU dhrystone of 12553 illustrates. So the Altix 350's IA64 does 'soundly outperform' the 1.4GHz Pentium III-S, at nearly the same clock speed.
The people who were grossly underwhelmed were the Socket 423 early adopters who bought 1.4GHz P4s, which were measurably slower than even the 1GHz Pentium III's for which they were supposed to be upgrades. It was hilarious.
As for the availability of CRIMM terminator modules, you can still get them pretty easily on Ebay. I did a search a few minutes ago and found around 100 listings for CRIMMs.
I have two on my desk right now here at work.... people who come in my office who are somewhat computer-saavy are very confused by memory modules with no chips on them.....and I enjoy watching the reactions....