Massive parallelism has several potential benefits, but I still think for the most part programs are going to be very serialized for the time being. I agree that loops are the biggest thing that can take advantage of parallelism though and will in the short-term help immensely.

I agree though, I see a time where the compiler and the OS will manage all parallelism without any forethought from the developer. You won't even need anything like .AsParallel() if the compiler becomes smart enough to figure it out for you and just do it.