More work for less money, cheaper to add another processor than another whole PC,even with the extra cost of a special motheboard.That applies to dual cores or dual processor boards.
It isnt double the speed though, you lose some due to latency and shared memory etc etc.
Software is an issue, not all OS's or apps do multiprocessing very well if at all.
They cost more, in some cases, lots more.