Moore's Law

We talked about Moore's Law the other day. This, of course, is the law that states that the number of transistors in a circuit will double every 2 years. In addition to being an observation of trends, it was stated that this has become a sort of "self-fulfilling prophecy". This is a very important factor in our technological world, but it also makes me wonder. How close are we to having computers do most of our work for us? I believe that, with minimal human input, computers will be able to do so much in the future that a lot of jobs, industries, and even just facets of everyday life will become obsolete. We will have computers readily available that can do complex calculus and physics formulas just by observation.
I am ambivalent toward the concept. On one hand, it would make things easier for everyone. Not to mention that all the programming in computers is put there by humans. So we wouldn't necessarily have an age of technological rule over humans or some hyped-up thing like that. However, those with skills would be completely unappreciated. This, combined with the number of human jobs taken by computers would make it difficult for people to find work. It's an interesting concept. I'm intrigued to find out how it will turn out in the near - and far - future.