As much as I love BBQ, if someone opened a restaurant and started smoking at 1AM everyday next to my house, I'd be pretty upset.
On the other hand, I probably wouldn't care if a couple of architects wanted to set up shop next to my house.
Again... this is NOT zoning.
Zoning is taking a parcel of raw land, subdividing it, and then, before anything is built, deciding what goes where. You'll say 'this square is a restaurant, slap a C1 zoning on it', and 'this square is a house, so slap an R1 on it'. You'll do this en masse, without any regard for the actual inhabitants or businesses occupying this district.
Things like setting minimum noise levels, street sizes, etc, are part of permitting. We can have a separate discussion here, but this is not 'zoning'.
The problem is that the primary purpose for US "zoning" was discrimination.
"Zoning" in Japan, for example, is different. It sets things like minimum acceptable noise levels, emissions, traffic flows, etc. Within that, everything is allowed.
Want to put a house in the middle of a commercial area? Sure, fine. But then you don't get to complain about the noise. Want to put a commercial building in a residential area? Sure, but you will get shut down if you make too much noise or create too much traffic.