If you do a lot of media encoding (video, etc.), then a P4 is the best choice (but stay away from the new Prescott P4, go with Northwood).
If you play a lot of games and similar applications which like the low latency of the on-die memory controller, go with the AMD Athlon64 or Athlon FX-51...