I think the misconception here is that an app has to be "cpu intensive" large or whatever to benefit from concurrency.
The way Grand Central Dispatch is "central" to managing Snow Leopards threads even your basic apps like Addressbook and mail will show improvement. Single Threaded apps will co-exist nicely with heavily threaded apps.
Snow Leopard has multiple API for GCD ...low level and high level. The key here is a dynamic system the throttles up/down depending on needs. OpenCL factors into this because it becomes just another compute resource for GCD to hand tasks off to.
Where this really comes into play for "general purpose" computing is the ability to leverage automation. Apple's still investing in Automator and improving it. They're still working on making Applescript a 1st class tool that works with Ruby and other scripting languages.
We really need to move away from the single task focus, that quite honestly begs for a faster processor, and move towards having apps and services fire up and the quiesce without user involvement.
I'm already looking at ways ot tapping Automator, Applescript, Quickeys and other scripting tools to let my computer do more heavy lifting and more file management. Why should I have to do all of this work? Isn't the expectation that the computer should be making my life easier?
Give me a LOT of RAM so that I don't have to shut down applications (which is antithetical to productivity as a closed app cannot work for you) and give me breadth of cores so that I do not feel the hit when background tasks fire up and give me SSD to keep up with the storage needs with speed and lights out low latency numbers.