The real problem isn't the OS as much as it is in applications.
A well-threaded O/S won't help make Photoshop or Avid run much faster, unless the application code is also able to use all of the cores that are present.
Some applications are inherently serial - you have to do step A, then step B (because step B depends on step A). It's not a matter of poor programming, it's that the task is serial. (Note that many Photoshop benchmarks quote "MP-aware" filters separately from actions that don't scale.)
For these "not well-threaded" applications, multiple cores will still be beneficial so that you can run multiple applications simultaneously - all at full speed.
There are some server-type applications (web or database) that run many (hundreds or thousands) threads simultaneously. (For a web server - each browser session is a natural thread.) For these applications, operating system efficiency is important. The reports that OSX is poor at threading (such as
Mac OS X limits server performance) aren't really that important for desktop apps that want to use all 4 cores (or soon 8).
http://www.anandtech.com/mac/showdoc.aspx?i=2436
The server performance of the Apple platform is, however, catastrophic.
...
Workstation apps will hardly mind, but the performance of server applications depends greatly on the threading, signalling and locking engine.