I've had dual-CPU systems for a long while. While my games machine is now a P4-2400, I used to use a dual P3-1000 with absolutely no problems.
Speedwise, you will get a slight benefit in games, but it will allow you to have something significant going on in the background without affecting your game.
You can make yourself a cheap dually rig if you go for the Athlon MP CPUs.