So my Core 2 Duo would start using both cores to perform every task the OS puts to it? Which would theoretically increase the speed of every task performed, from watching a movie to playing a game to building a spreadsheet, by 70-90% wouldn't it? *Plus* whatever help the GPU can throw in?
Sounds like a full "point" $129 upgrade to me. And well worth it.
For some things, yes, for others, no.
Many tasks, such as watching a movie (presuming it's HD), would not speed up so much, due to the fact that the computer is playing the movie back from the hard drive. There's a lot of data going through, and right now hard drives are often the bottleneck for these kinds of operations. On my MacBook Pro, I can play a 1080p, 15000kbps HD movie file I ripped from one of my HD-DVDs, but seeking through it is a bear... because of the slow hard drive access speeds. My processor usage rarely breaks through 70% when watching the movie.
Now, if you were crunching numbers in a spreadsheet, or compressing a movie (say, to H.264), speeds could improve dramatically... especially with the help of the graphics processor (which normally sits almost at idle in the average computer, while you're simply browsing the web or typing a document).