Best processor for a new computer?

Core 2 Duo w/ 4 MB cache (6320, 6420, 6600, 6700)
even a Quad Core - dont even look at the other processors - they are not as good.

The C2D are extremely fast, OC great, and not expensive

But the CPU doesnt have as much bearing on pc performance as other things (like RAM)
C2D, even without any OC my E6300 cut my video compression time from about 1 hr to 10 minutes. I sometimes compress 5 at the same time. My previous CPU was a Barton 2500XP+ running OCed at 3300+ speeds.

If you want to oc, get a good mobo and ram.
Core duo is yor best bet, price reliabilty and usefull life to mention a few items, I use dual quad core intel xeon v 8s oh but wait for the price of these 2 cpus I could buy several top end del pcs nevermind, for the 300$+ to update an old dell? why not add a few hundred more and get a new pc altogeather andd sell teh old dell for a subsidation on the price of a completely new pc therefor costing you around th same or lesser than a simple cpu upgrade?
Oh I have a Core 2 Duo running at 1.73 and it runs fantastic. I love it. I would get a core 2 duo because it runs fast and if you are interseted in getting the 64bit OS of Vista Ultimate, you would need a 64 bit processor.
If you want something that will still be good five years from now, and would be excellent today, you should think about getting a 64 bit processor. Most of the processors out now are 32 bit, which means that they have half the computing power; this standard will probably change within the next three years. 64 bit processors are commonly used nowadays for heavy duty computing, like in media production and real time financial analysis, but will be normal in several years.
The best 64 bit processors out now are the AMD Athlon 64, and the Intel Itanium. Even if you don't run a 64 bit OS now, like the Windows XP Media Edition 64x, you will save the hassle of replacing your motherboard the next time you switch an OS.
Your needs are not too demanding and could be easily met by the new Pentiums that are based on C2D technology.

http://www.xbitlabs.com/articles/cpu/display/pentium-e2160.html