I'm skeptical we'll see something like this for _nontrivial_ applications, especially highly tuned applications (search, financial, etc).
I think we will have examples of toy applications that can be automatically parallelized.
Parallel Linq (plinq) is a good example. You can easily make course grained operation concurrent. However, for truly fine grained stuff, the compiler isn't "smart enough." (see On Being Sufficiently Smart - http://prog21.dadgum.com/40.html)
I hope I'm wrong and we see some major advances in magic err I mean compiler design.