You could always have Japanese style zoning. To simplify a lot, you can build houses in residential zones, you can build stores or houses in commercial zones, and you can build factories, stores, or houses in industrial zones. So people who want peace and quite have a place for it and nobody is allowed to surprise you with a pig offal disposal site next door. But if people really want to build houses in an industrial zone they can.
People will definitely still complain about that factory. People move into houses directly under the approach path for an airport then try to get the airport shut down because of the noise. People will move in next to a sewage treatment plant and then complain about the smell.
There are legitimate complaints, I think - no one wants a pig offal disposal site next door in their residential neighborhood. But we've gone way overboard in letting zoning dictate what can go where.
> They are not a typical case.
But they absolutely are on YC's radar, because San Fran and the bay area in general are ground zero for the housing crisis in those kinds of desirable places.