You wrote "the simple solution is to build more housing", and point to Houston and Dallas as examples where there is no housing problem.
Yglesias proposes a more restricted solution, high-density zoning. This lets people build more housing in the same area, rather than going outwards as Houston and Dallas do.
gamblor956 mentioned a problem which is an issue in London and a few other places; foreign investment in (nearly unused) second homes has secondary negative effects. For example, with fewer actual residents there are fewer restaurants, stores, and other services for those people who live there, and who moved there because there were services.
The NYT at http://www.nytimes.com/2013/04/02/world/europe/a-slice-of-lo... gives a few real-world examples. It's made worse in London by the low tax rate for secondary homes, which is why Vancouver specifically wants higher tax rates for those homes.
Along the lines of Yglesias' description in Slate, suppose foreigners purchased American-made luxury cars from union factories in Detroit and parked them all in your neighborhood. As Yglesias says, "Great news, right?" It builds a lot of upstream production in the US, and "it should be providing lots of employment for working class men."
Except that now you don't have anywhere to park your own car, or for visitors to park, or even for the delivery truck to park.
How much livability would you give up for the benefit of the rest of the country? How much livability should Vancouver residents give up?
Foreign ownership of unused housing decreases density. I think it's possible to compensate by building even more density, with the expectation that 1/3rd of it won't be used. (Hopefully the market will be stable enough.) But my point is that it isn't as simple as looking towards Houston and Dallas.
Early indications are that it will succeed in that goal.
I saw this a lot in the Malaysian market during the previous frothy years until 2014, many many vacant units, zero ability to negotiate rent - owners were going to get their asking price (rent or sale) or sit on an empty house/apartment. They were making ~10% a year so who can blame them. Then the Malaysian government slapped a retroactive (!) punitive capital gains tax on foreigners. In addition Selangor state (think most of the Kuala Lumpur suburban area) banned foreigners from buying landed, non-strata property.
Instead of lowering prices, this had the effect of driving the transactions to almost zero (very few forced sellers), very little property over RM1m (the minimum limit for foreigner purchase) sells these days. Lots of RE agents are losing their jobs/driving uber to make ends meet. The foreign (predominantly Chinese) owners have deep pockets and holding power. The coming years will be interesting if it continues though.
I look forward to reading the economic thesis papers in the future on whether this Canadian measure works and what the unintended 2nd/3rd order effects are. Its fun when govt's experiment like this, good grist for the mill for economic/psychological research.