If you are talking about Core 2 Duos, there is no reason to not get a 45 nm chip. The 45 nm chips are faster, produce less heat, oc better, and are about the same price as the 65 nm versions.
If you are talking about Core 2 Quads, well that is a different matter. This is the current pricing at newegg
q6600, 184.99
2.40 GHz, 9x multipler, 2 mb cache per core (8 total), 1066 fsb
q8200, 189.99
2.33 GHz, 7x multipler, 1 mb cache per core (4 total), 1333 fsb
q9300, 249.99
2.50 GHz, 7.5x multipler, 1.5 mb cache per core (6 total), 1333 fsb
q9550, 309.99
2.83 GHz, 8.5x multipler, 3 mb cache per core (12 total), 1333 fsb
Now when you overclock you increase the fsb speed for increasing the bus speed * the multipler will get you a faster ghz speed. Notice that the q6600 has the fastest multiplier of the quads I listed. Now when you overlock the chip creates more heat and needs a higher voltage to be stable. At the same time any 45nm chip will require less heat and less voltage due to its manufacturing process.
Thus even though you can get a cooler chip with a 45 nm due to the multipler being so low on the cheaper quads a q6600 would overlock better than anything in the 8000 series of quads and would be comparable to anything in the 9x00 series of quads. It is in the 9x50 series of quads you have a far better chip but by then you are spending almost double on the cpu.
Thus right now if you OC you get a Core 2 Duo (anything in the 7000 or 8000 series), a q6600, or an I7. You mostly iqnore the rest of intels offerings. The rest of the quads are going to non overlockers, traditional oems, and business related products.