As it seems to be confusing for some people, this issue needs to be cleared up:
Applications do STILL need to be optimized for dual processors if they want to take advantage of both. The big change in OS X is that the OS itself natively uses both processors.
Let's say you have a 3D rendering application that is not optimized for dual processors, and you have a processor-intensive video editing application that is also not optimized for dual processors, and then you have Photoshop running natively on OS X that is optimized for dual processors. Say all of these programs run natively on OS X.
So you open your 3D rendering application and have it start a render. Because it is not optimized for dual processors, it can only take advantage of one processor. But because OS X is optimized for dual processors, it can assign this 3D rendering app to either processor it wants.
Same thing with the video editing application. OS X decides which processor would benefit the video editing application more, the 1st or the 2nd. Obviously, since the 3D rendering application is going to suck as much as it can out of the first processor, OS X will stick this video editing application into the second processor, because it can get more power that way.
Now you open up Photoshop. So let's say you start a lengthy gaussian blur filter on a huge file. Because Photoshop is optimized for dual processors, it can suck up whatever processing cycles are not used on both the first and the second processor. If it was not optimized for dual processors, OS X would have to allocate it specifically to one or the other processor. So in the case of Photoshop in this situation, it would significantly help to have dual processors if you're doing other processor-intensive tasks.
Now let's take all of these apps on their own. Either of the unoptimized-for-dual-processor applications still can only run on one processor even if other apps aren't using up those cycles, so OS X would still have to put these to one or the other processor. The result? Dual processors do not have much of an effect on these applications -- it will only help by allocating other tasks to the other processor, so as to allow more cycles for that process dedicated to that one processor.
For Photoshop on it's own? If you're not running either of the other applications, Photoshop can use almost all cycles of BOTH processors. In this case, dual processors would probably significantly help the rendering speed.
In OS 9, the operating system could not allocate any apps to the second processor. Only apps that were optimized for both processors could take advantage of it. Thus, dual processor Macs were basically pointless in the Classic MacOS days, except for maybe Photoshop.
So, what was this explanation all for? To show you that dual processors does not mean you have a computer running at twice the MHz. It is not that simple. Depending on the circumstances, dual processors can help you significantly, or not. However, since OS X debuted in March, I can assure you that buying a dual processor Mac is now significantly faster than buying a single processor Mac at the same or slightly higher speeds. Why? Because OS X can allocate processors to either processor, thus doubling the amount of power, BUT NOT MHZ, that you have to run your apps.
Oh, and by the way -- I think the flavor of UNIX that OS X sits on top of, namely BSD UNIX, can only handle 1-32 processor systems. I can't claim this for certain, but I remember hearing that somewhere.