I've used a dualie for 3D modelling and other stuff. The "and other stuff" is where a dualie can come in useful. If the render job is going to take several hours (or days) it's nice to have a second CPU for doing the "other stuff" without having the performance level of a 286 due to the render job that's running in the background. Of course, having multi-threaded rendering is a nice option too, but my 3D software (Caligari trueSpace 4.3) had bugs that caused it to crash when using both CPUs for rendering, especially with area lights.
Overall, I'd have to say dualies have their uses. If you are trying to multi-task and your CPU is bogged down by an ongoing process in the background, then adding a second CPU will help you, provided you have enough RAM to suit the need (and of course, your SMP-enabled OS). But just having the second 1GHz CPU in there won't make a noticable difference in run-of-the-mill activities like surfing the Internet while using ICQ, IRC, listening to music and such.