Perhaps the LGA-775 Celeron would be a good short-term solution until Intel fixes the Prescott heat problems?
CPU, process, bus, L2 cache
Celeron, 90 nm, 533 MHZ, 256 KB
P4, 90 nm, 800 MHZ, 1 MB
I could buy 800 MHZ ram for a P4 but run it at Celeron speeds until I upgrade. That way I get the better power, cooling, and expansion capability of an LGA-775 motherboard but run a simpler processor that puts out less heat (slower bus speed, less cache, and I assume no hyper-threading). Then in the future I can upgrade the cpu, video card, and other components as they improve and come down in price.
Yes, it will be slower than a current Northwood cpu but it took Intel time to improve the first Pentium (which wasn't much faster than a 486 when it was first released). And compared to my current P3-600 any P4 would be an improvement.
P.S. I wonder if Intel will ship any LGA-775 Northwood cpus other than the pricey extreme edition?