I've asked this question to a person I know who is an academic in economics (not a world-renowned economist, just someone who does economics at university), for what it's worth, and what she told me is--in my paraphrased understanding--that if a market goes up "naturally," or by the usual forces people regularly expect (usually around jobs), then wages tend to also go up so housing and other goods remain mostly affordable relative to local wages being paid.
The issue in cities and areas like Vancouver and Seattle and San Francisco--ones that aren't just hubs for high-paying technology jobs but also ones where overseas capital has made inrushes--is that wages haven't been able to keep up with the outside capital. So property of all types (it's just that most people only directly care about residential property, but commercial property also goes up and that increases the cost of other things in the local economy) rises in price while wages don't, so a major disconnect starts to happen.
This is a two-paragraph summary of a nearly three-hour conversation we had, so there's a lot of nuance I've left out. Zoning, development, density, and all of the rest around property use also affect prices and, according to her, probably more than inbound foreign money, but the added money has an influence.