IMHO Dual core is the next step in CPU technology because chip developers (Intel,AMD) have "hit the wall" in their ability to continue to increase speed and performance on the single core platform(see todays article on Anandtech front page). The problem with dual core is that just like dual processor systems today, only a handful of non-server applications are written for and optimized for dual processing. On everything else your second processor is nothing more than a spare.
This will eventually drive software developers to optimize games and desktop apps for dual computing, but this will take time. And the amount of time it takes will be dependant on how quickly dual core grows on the desktop platform. First adopters will most likely pay the price of running at half speed on the majority of applications for a year or more.
Dual core will be very much like SLI is now, for the 3 or 4 games that take advantage its wonderful, for everything else its an extra $500 heater in your case to keep your rig nice and toasty Mainly bragging rights.
My next upgrade will be after dual core and windows64 have been fully implemented and software developers have responded with applications that utilize this new technology. By then the next gen GPU should be out, and I can pick up a pair of 6800gts on ebay for $50 each and finally hit 10,000 in 3dm05