I throw this example out all the time, because it's still so impressive to me:
HERE is why dual processors (especially running OS X) is huge...
On each of my fairly modest DP machines (original DP 1 GHZ-1 GIG RAM and a DP 867-768 RAM) I can consistently do the following all at the same time with minimal performance slowdown:
1. Download a large file from the internet
2. Print a large document to an inkjet printer
3. Capture DV quality video, one full hour no lost frames
4. Render After Effects files in the background
5. Surf the web
6. Hop back and forth between who-knows-how-many apps
7. RIP the crap out of MP3s and AACs. As fast as you can read 'em in, they're ripped.
8. Burn a stack of CDs or DVDs
Again, I have to reiterate, all of this is happening AT THE SAME TIME! Granted, OS X alone is a huge part of why this is possible, but that second processor is also huge. You flat out cannot do the above in OS 9, period. Go ahead and try, I dare you. In fact, go ahead and try it Windows consistently. Also, I think even the very best single proc Mac would have a hard time pulling off that list (anyone tried it on a an SP G5?) I do it ALL THE TIME on my DPs.
For day to day, general user minimal requirements, a second processor will go mostly unnoticed, but if you plan on having a bunch of apps open, maybe working in Photoshop while iPhoto is doing something and downloading some files at the same time then it might be worth it to you. If you just launch a word processor and nothing else, don't waste your money. Get a cool looking iMac and enjoy. My experience has shown that for most general apps, the second proc isn't that helpful, but it opens up the computer for hopping around without slowdown. The G5 is a monster at this. The architecture is insane. If you run some CPU monitoring tests, you'll be hard pressed to peak the CPU. G4s peak with far less thrown at it.
On the higher end, Photoshop makes marginal use of the second processor (despite all claims--plus, it's not even multi-threaded, c'mon!), Final Cut and FCE make excellent use of DP for rendering and RT effects, not so much for general interface editing, high end 3D apps use multiple processors, but are typically significantly behind PC rendering speeds, so they're still playing catch up (getting there tho!), After Effects munches on the DP, iTunes freaking flies on a DP, some games (very few I think) will crank on that 2nd proc (Giants and Quake, right? any more?)
In short, I have a DP machine and work and at home and I will NEVER go back to a single proc machine. I also have several single proc Macs that I use daily, so I'm plenty familiar with the benefits of the DP. It's huge very big for anyone who uses their Mac seriously or considers themselves a "Power" user.
-----------
As for PowerMacs being designed for home users or not, I think we're into a semantics argument. Power is relative. Today's crappiest iMac is (maybe) better then the very best "workstation" of ten years ago. What is definitely true about the PowerMac and iMac lines is that they are MARKETED to pro users and home users differently. Just like today's lowliest iBook is way better than a G3 PowerBook of only four years ago. I don't think any of us would say that the current iBook is DESIGNED for a home user so much as it is MARKETED to one due to its current relative power to the AlumBooks/TiBooks/PowerBooks or whatever they're calling them these days.