Pentium 4 can't rightfully be called "worst" by any metric. Prescott didn't have issues with overheating, either. It definitely used a load of power, but it didn't break thermal limits any more than other CPUs.
Prescott wasn't an awful performer, either. It was sometimes slightly faster than Northwood, sometimes slightly slower. It introduced EM64T, VT-X, and SSE3; it also brought EIST to the desktop market later in its life. Pentium 4 was overshadowed by Pentium III early in its life, in a close competition with Athlon XP by the time Northwood was released, and ultimately fell far behind when Athlon 64 was released. Despite this, it wasn't a broken CPU.
The 1.13 GHz Coppermine, for example, was a broken CPU. It was rushed to market because AMD just humiliated Intel by getting a 1.0 GHz CPU to market first. Some 1.13 GHz Coppermines actually made it to market before being recalled, apparently. The review units were generally extremely unstable.
The initial revision of Agena had to deal with the TLB bug. It wasn't as serious as the Coppermine issue, but it didn't get recalled. It was replaced relatively quickly.
Honestly, I'd consider the "Emergency Edition" Gallatin Pentium 4s "worse" processors than the Prescott line. They were announced as an "oshi" reaction to the impending release of K8. They were Northwood cores with 2 MB of L3 cache taped on, and nothing more; they completely failed to compete with the FX-51, and they generally didn't outperform Northwood/Prescott.