As much as one would like to be able to predict the future, it is not possible.
In my 31 years selling property on the Peninsula, most markets move together.
If prices increase in Palo Alto, they will increase in Mt. View.
If prices dorp in San Carlos, they will also drop in Belmont.
So I do not think one can predict which city will do better than another.
If you believe in this area and the local economy over the next 5 years, then property values will increase in ALL cities on the Peninsula.
I would say if you job is stable and you know you will be in this area for 5 to 7 years and if you buy within your financial means, then buying a house will be a good thing for you.
Most of the people who get hurt in real estate buy beyond their financial means.
If you buy in a prudent financial matter, I believe long-term you will come out a winner by buying now.
Interest rates are down, prices are down.
Let me know if I can be of further assistance.
I was showing property in Redwood Shores on Sunday.