you'd really have to decide which make you want to go, Intel or AMD, before someone could give you an opinion. What motherboard will you be using? RAM, GPU, etc? If you're looking for a generic answer, the E8400 will do everything you want, unless your using multithreaded apps, then a quad. You're gonna get faster performance out of Intels, used to be better price out of AMD, but that doesnt even neccessirly hold true anymore.
If you provide a budget, a main uses of what you want a PC to do, and a CPU make option, you'll get more detailed answers.
No offense, but right now, the way you've posed your inquiry, it'll just spin into an Intel vs AMD and Quad vs Dual Core thread.
There's a ton of those in the folder, peruse them.
Penewah!
It's a Peanut & Bumblebee World! MSI K9A2 790FX / AMD Phenom 9950BE 125W Quad /Xiggie120/Antec 1200/HD4850Xfired/mushkinBlack CL4, 4GB DDR2800 /Samsung Spinpoint 640GB&320GB-SATA/PCPC 750W CF Silencer/ LITE-ON & ASUS DVD±R/Vista 64-bit/Dual 22" HannaG Mons/ WD My Book 500GB/Logitech X-530 70 watts RMS 5.1 Black Speaker System /Build2: Biostar 780G/AMD 4600+ x 2 @ 3.0/OCZ Platinum Rev2 2 x 1GB DDR2800 /Logysis Acrylic/Vista/Ubuntu 8.1 / Corsair 550W PSU