Guys, I'm seeing everyone here talk about the higher-end Intels, the dual-cores, the quads, and the i7s. But on an relatively limited budget (about $800), would it still be worth getting the Celeron? I'm thinking of a budget all-purpose machine that can breeze through all the basic tasks, and has enough power for running even some of those powerful games at decent settings. I mean, it's more about the GPU rather than the CPU nowadays, right?
I can't think of any reason to buy a Celeron when an e5200 is just $5 more! An e5200 Wolfdale with 2 MB of L2 cache will runs circles around an e1500 Celeron with its 512KB of L2 cache! I know this because I bought an e1200 last year and an e5200 this year and now I'm trying to sell the e1200, maybe worth $25?
I've played Crysis on both these CPUs with a 9800 GT and it's like night day on load times and framerates. Forget about the Celeron.
My celeron 420 rig is nice for office apps, web surfing, dvd playback, and online flash video (youtube, hulu). It's even enough for old games (COD, Quake III, etc.). However, I would never recommend it or any of the dual core Celerons for any sort of modern gaming. They are just too much of a bottle neck for today's highend graphics cards. The e5200, when overclocked, will provide enough headroom to take advantage of a good portion of a highend graphics card.