Dual processors is going to help you in an OS that can use both CPUs, along with applications that are coded for it, or simply multithreaded. Not all games will take advantage of SMP, but many compilers, digital editing, etc. will. For 99% of the users out there, its overkill.
vash