Yeah. Some things need to be kept out. Funnily enough, it's nearly always car related. Repair shops, gas stations, parking lots, ... Nothing trashes up a city more than cars.

I think this is why people tend to like the Japanese zoning model where things are divided up into different "nuisance" levels. Something like an auto shop would be more of a nuisance than say a coffee shop. You're allowed to build anything in a zone as long as it's below the zone's nuisance level. This will help keep real industrial style work away from where people are living and eating, but allows for so much more retail opportunity in those zones.

When you kick out all those businesses that the upper middle class finds unsightly there ceases to be enough latent economic activity for the businesses you do like to exist in an economically sustainable manner.

Banning automotive repair might be ok by itself but there's another idiot who wants to ban X, and Y and Z and their complaints are just as valid as yours and the status quo is what you get when you try and accommodate all of them.

Sure, write that into the zoning law. No obnoxious or environmentally harming activity. A far cry from buying some milk and cereal in the morning.

Zoning laws are just a great way to implement whatever priorities people have for the places they live and access.

Want to prioritize walkability to shops? Zoning is a great way to make that happen.

Want to prioritize keeping noisy things away from residential areas? Zoning is great for that too!

Want to make a socially segregated city? You can absolutely do that with zoning!

Zoning is a super great tool, it's just that the things it optimizes for are sometimes misguided (or in some cases straight-up harmful).