Depends on what else you need it for. Any fairly modern CPU won't bottleneck a 4670.
I have an Athlon II x2 (easily overclocked to 3.6ghz) and love it. It works great with my Radeon 5750, and it is a little less than $60 on Newegg for the 245. But if you spend $40 more, you could go for the quad-core Athlon II x4 640. Depends on how much of a power user you are.
EDIT: I don't know much about using ddr2 ram with it... You might need to get an am2+ motherboard and then the am2+ version of those cpus. But I really don't know much about that at all.