kotrtim is, frankly, wrong about the memory speeds. for your needs it won't make a bit of a difference. now, as for the processors, any of the suggestions here should outdo your p4. up until a few weeks ago i was using a 939 rig with a 1.8ghz sempron that had 128k l2 cache (sempron 3000; basically the same as the 3200 you're looking at) for general tasks with 1gb of ram and it ran pretty smoothly...you just need 1gb or more of ram for that. however, i would strongly suggest you spend the few extra bucks for the extra cache, it would really help things out since anything less than 512k l2 cache really holds back the k8 architecture. also, i had the same pentium 4 you have in a previous rig. for general purposes they were pretty close i think. but you really should try to get an x2 or at least an athlon, it will really just make things so much smoother.
so, here's the order that i'd suggest them:
1. athlon 64 x2 3600 (brisbane)
2. athlon 64 (3200/3000)
3. sempron 64 3400
4. sempron 64 3200
those semprons are basically an athlon 64 3000 with less cache; the athlon has 512kb, and, as i said earlier, anything less really does hold back the architecture, which is also the reason why, if you go with the x2, you should get the brisbane, as the windsor has 256kb l2 cache per core; the brisbane has 512kb per core, and it more than makes up for the 100mhz lower clock speed.
EDIT: also you may want to check the fs/ft forum, you can usually pick up decent processors (lower end athlons, etc) for dirt cheap there.