I agree there are times when a overclock is needed.
I also think the Core 2 Duo is what started the madness (Though some could argue the Thunderbird platform from AMD is a rightful candidate). I have to admit the prospect of overclocking something from 1.86 to 3GHZ was really appealing back in the day since you were basically getting triple the performance compared to a Pentium 4 at the time. Same with the Q6600 which is legendary. Suffering through the Pentium 4 and getting something as nice as Conroe brought me alot of fun.
But on the other hand,its just like the SB processors with no unlocked multi, they are considered garbage here(SB 2500) when in actuality I would rather have one of those at stock over a massively overclocked C2Q Q9550 or Phenom 960. The architecture is what I am interested in now more than anything, maybe I have evolved or maybe devolved, who knows
But it's always fun seeing people getting these massive overclocks of course.