Vancouver is 80% SFHs because of zoning. Recently the government allowed multiplexes in SFH zones, and suddenly every new construction is a multiplex, and families are looking at rebuilding their houses to maximize value.
If there was no artificial zoning, then Vancouver would be a lot denser and current SFHs would be a lot more expensive (and they're already expensive, 2M on average). This is true across most NA cities.
My argument is not that nobody wants SFHs. I'm sure they do, but desires are not fixed. If you had to choose between an SFH 1 hour away from the city, and a row house 15 minutes away, you might go with the row house.
And yes, sometimes people want to live far. There's lots of reasons for that, and that's ok, as long as they're paying the real value of it. By the way, this would mean massive property taxes because sparse infrastructure is very expensive.