if you're buying new, there would be no reason to buy something other than a P4 with either RDRAM or DDR.
That being said, I run an Athlon 850 with 512 SDRAM, 2 Matrox G450 cards to display on 4 monitors, and I get my fills fast.
The faster the processor, the more windows you could have...