2nd, I personally don't like AMD processors, but;
Regardless, a high end Athlon X2, Phenom, or Core 2 Duo are all going to give you ample computing power. With any of them, having enough RAM available and a good graphics card are as important as which CPU you get.
For COST/PERFORMANCE, AMD...