Enshrining a right to only live next to other residences is how we end up in this problem of boring neighborhoods that require lots of travel just to get to where you want to go.
In old large eastern US cities and in towns of any size in other countries I've been in (Mexico, Japan) there is MUCH more mixed use. You might see a motorcycle repair shop in between a couple of regular single family homes. Nobody seems to mind. I don't get why we're special and weird like this.
Most of lower Manhattan, which is so valued now, could not be built legally today. It was built before zoning codes.
I'm not against mild zoning codes that merely slow down rather than block change. For example, rather than a named maximum height, say that no building can be built more than twice the average building height in the area within a certain radius. Or, the percentage of nonresidential uses within an area cannot increase by more than 2% per year, or something.
This way in the short term, a neighborhood cannot be transformed overnight. But, it can be transformed slowly over decades towards what the market will bear, ie what people actually want and are willing to pay for.
This isn't a libertarian fantasy, it's just how towns used to work in the US before zoning and how they work in many other less backwards parts of the world...