If you own a sfh, you want development around you... The denser your lands zoning is, the more it's worth. Add infrastructure and the value goes up too.
You want offices near you but no more housing, so that people work near you and are forced to live closer to you, and have to buy houses near you for ever-increasing prices.
And people who own homes (older than most of the population) are used to driving everywhere, they don't want people constantly walking in front of their houses. They all want their own cul-de-sacs.
So both remain in balance, prices don't increase and you get little or no financial benefits. Also, a house surrounded by high rises in a very busy street has far less relative value than a house in a quiet street where your kids can play around. Cities bring strangers, crime, pollution, noise, etc.
But if you increase job density without increasing housing density, then you reap massive financial benefits from increasing housing prices.
Yes, but that's only for holdouts, which is a game of chicken. And after the developers build around you, you're done, your home value plunges as you're surrounded by traffic and apartments.
"Now, going back to jobs, in practicality, allowing upzones, also tends to bring way more jobs - more coffee shops / corporate towers etc."
The two are unrelated. Cities have a lot of exclusive-use commercial or residential areas. You can increase the same jobs without having more residents, which increases value for the home-owners.
Which is exactly what is happening in the US.