I think you read my comment backwards? I was trying to say that you get more reliable returns if you invest your down payment in a diversified fund than if you use it to purchase a house.
As far as "markets where people want to live" goes: yes, in any market, you can outperform the average if you can predict the future better than other investors. Some of the places around the Mississippi River probably used to be considered good investments; now they aren't. If this whole full-time remote thing catches on, it's possible that the bay-area will drop in prices. It's also possible that only part-time remote catches on, and interviews resume in person so people want to stay in the Bay Area. Heck, it's unlikely, but possible, that Cupertino or Saratoga decides to rezone large swaths of the town for more density and the increase in supply drops prices.
As far as "markets where people want to live" goes: yes, in any market, you can outperform the average if you can predict the future better than other investors. Some of the places around the Mississippi River probably used to be considered good investments; now they aren't. If this whole full-time remote thing catches on, it's possible that the bay-area will drop in prices. It's also possible that only part-time remote catches on, and interviews resume in person so people want to stay in the Bay Area. Heck, it's unlikely, but possible, that Cupertino or Saratoga decides to rezone large swaths of the town for more density and the increase in supply drops prices.