I believe these tools change the value of different skill sets in a very profound ways. Being good with rules of a programming language and syntax is no longer as valuable as it used to be.
Understanding the problem space is becoming more valuable. Strength in architecture of a solution is another skill that is becoming very valuable.
We are close to getting to a point where someone with overall general (and perhaps not very detailed) understanding of arch and design and a good understanding of the problem space and having a good taste in usability will be able to create awesome solutinos.
I can't wait to see these solutions being created by one or two person teams.