if you're overclocking, then the core 2 duo is the best processor all the way. in fact even if you arent, it still is, for the money at least.
this is because it benchmarks higher in all benchmarks except for memory speed, which actually doesnt matter for a whole lot of applications anyways. if we were talking 4 cores then sure, memory speed would matter, but only if you were utilizing all the cores.
not to mention, they're better than any AMD proc, and theyre overclockable to AT LEAST 3ghz. you should be able to push it to 3.4ghz fairly easily. its got the better factors of both netburst and K8 architecture, in that it has massive overclocking ability... and GREAT architecture.
so in conclusion, its better at stock, and has more overclocking potential than most processors on the market.
i mean cromewell obviously linked you to show you that athlon 64 is better, but the article he linked you to was called
"Game Over? Core 2 Duo Knocks Out Athlon 64"
wow.