<< They are only 2 situations where Dual processors increase performance. One is when Multitasking. It does help when multitasking. 2 like you said when the application is SMP optimized. It really isn't worth it IMO for the power user. >>
Ahh you forgot situation number 3. Suppose you have a bloated operating system that is capable of using more than one processor. In the single processor machine, you have to share the CPU time betweeen your programs and the operating system. In a dual processor machine, the operating system may be handled by one CPU and a CPU intensive program will be handled by the other processor. The benefit depends on how bloated the OS is. For example, WinNT takes about 2% of my resources, Win2k takes roughly 4%. I haven't yet tried WinXP but lets assume it takes 5% of the CPU time to do all of its bloated stuff. Thus I will see a 2-5% improvement on programs that aren't even SMP capable. Since it takes a 10% improvement to be really noticible, this is a minor improvement. But if you want all the juice you can get, 2% may be what you are looking for.
The benefit in programs capable of using both processors varies drastically. Suppose I try a small task which a single processor is quite capable of performing - I get at most a 10% improvement when using both processors to do that same task. When I try a task that requires one processor several hours/days to finish - I get a 80%-110% improvement by using both of my processors. And of course, in between I often see 30%-50% speed improvement, but then I usually never run medium sided problems. There is no single answer we can give you, unless we knew exactly which programs you will use and how heavily you will tax them.
By the way, I use two different dual processor machines every day (dual 450 MHz and dual 1.7 GHz). For my work, the extra cost saves me lots of time and money. It probably isn't worth the extra cost for the vast majority of users.
Edit: corrected spelling.