No, it wasn't. The 90nm S939 3000+:es (running at 1800MHz base clock) could easily reach 2.4ish, or a 33% overclock. If anything, overclocking them both makes the Pentium D look worse.
No, it doesn't. And going from 2.66 to 3.6GHz is a 35% overclock.
Yes, it really was much slower in single-threaded. Crucially, it's not fast enough for a seamless desktop experience. I know, I used pentium D's at school and an A64 3000+ at home. The difference in general usability was night and day. Also, I disagree with multicore being a necessity from 2007 on. If you were stuck on that chip for years, A64 would actually be a much better choice, because flash videos and the like do generally run smoothly on it, but won't on a pentium D. In fact, as my primary machine broke down, I just used that same A64 for my home desktop for about a month. It's still usable (if slow). Pentium D wasn't usable in the same way the day it was released.
No, it wasn't. It depended on the program. iTunes is strictly single-threaded and there the Pentium D was still faster. Your experience with a Pentium D at school proves little, if nothing. Unlike Bulldozer, the Pentium D was able to overcome its huge IPC deficit by the way of much higher clock speeds. While something like the Athlon 64 maxed out at 2.5-2.8GHz most of the time the Pentium D could reach 3.6-4.0GHz.
And the Pentium D is definitely more usable in day-to-day use. Multi-tasking is an absolute chore on a single-core CPU, and even if a program can't take advantage of two cores, the operating system can schedule processes between both, making everything smoother. Flash video in SD should also run in SD fine on both, and on HD it won't run good in either. If your argument is gonna be about that it better be based on real-world usage taking into account a GPU handling the decoding. Even in 2006 with Vista, disregarding power consumption, the Pentium D would be a much better CPU for day-to-day use. While there's little difference in most computers when it comes to speed on normal applications between dual and quad-cores, going from a single-core to a dual-core makes a HUGE difference. You may also want to know that software taking advantage of two cores doesn't make it multi-threaded, but merely mildly multi-threaded.
The problem was that 3.6GHz simply wasn't enough to catch up with the A64, especially if you also overclock the AMD chip. Which you could do with a lot less investment in the psu, mb, and cooling.
The benchmarks I posted clearly prove that wrong at stock speeds, and the Pentium also had higher overclocking headroom. 3.6GHz was what you'd do without the stock heatsink, but 4GHz was achievable with a good air cooler.
Notice what's common with all those benchmarks? Media encoding. The full list at the Anandtech review is even funnier -- they basically tested a buch of apps that thread well + a few games. Pentium D sucked in general desktop use, the same way Atom does today. Like BD, having more weak cores just really isn't that interesting.
3D rendering isn't media encoding, but audio encoding is. And the funny thing is, the Pentium D still did better there despite it being completely single-threaded. The Pentium D wasn't bad for its performance but for its power consumption. Bulldozer is easily a lot worse, since it both consumes a lot more and isn't overall comparable in performance. While it has a lot lower IPC than Sandy Bridge, it doesn't have the frequencies to make up for it like the Pentium D did.