If every empty house on the market in SF or Vancouver came on the market tomorrow it wouldn't make a dent in housing prices.

Vancouver has actually seen some price declines as recently as 2018 and CMHC says it is driven by new construction - any jurisdiction where you can't build will attract investors that can afford to sit on empty properties and still expect a reasonable return. It is just the iron law of modern real estate.