Well, the only situation now where multicore is a burden is when using an operating system that can't use more than one core... So I guess that is rather ironicaly probably only AmigaOS now... 
Depends on what your definition of "an operating system using more than one core" is
What would interest me more than just having one program crunching numbers within one core, another crunching numbers in another core, a third crunching numbers in a third core etc is if the operating system itself could could be split across the cores running a different task in each core, or i could get one program to split itself across each core. I hardly ever need to encode more than on video/dvd at the same time, but I'd like to have four cores all working to decode that single DVD at the same time. At the moment this doesn't happen particularly well, if at all, as most software and the OS is not designed to detach into parallel tasks like that. Most benchmarks I've seen from dual core systems are at best 30-50% faster than a single core at the same clock speed, and for some benchmarks with some dual core cpu's the dual core can even be slower. (Windows 7 might be better, i haven't had any experience with it)