My cousin's Celeron D died, and he is looking for a new CPU. His budget is around $75, and he told me three processors that he likes. The first is a Celeron e3400 ($45 w/ tax at MC,) next a Pentium e5700 ($66 w/ tax at MC,) and last is an e7200 ($75 w/ shipping on ebay.) His primary use is watching high def videos and playing games (mostly source games) at 720p.
GPU: 9600gt 512mb
Ram: 2x2gb G.Skill 800mhz
He is really just wondering if the extra cache is worth the extra money, as he would probably have the CPU clocked at 3.0ghz.
Really with a 9600GT, any of those CPU's are fine. I'm pretty sure there isn't much difference above 3Ghz since the video card is the bottle neck. I'm biased against the E7200, I had an early one and it was an overclocking dog. A new E5700 in my mind is the safest bet.