Sure, you don't want someone to open a chemical factory next to your backyard. You don't want heave transport moving through your side street. You don't want the nice house with a mountain view to suddenly have twenty story high rises obstructing that view, it makes sense that most places have restrictions on this. However, when did people think it is a good idea to make one office job different from another office job? In Germany(the ultimate bureaucrat heaven), there is as far as I'm aware no zoning issue preventing office work in residential buildings ( residential areas might have limits as to how big buildings might be, so the apple spaceship probably wouldn't be allowed in a historic residential area, but opening a doctors office, law firm or software consulting company in a residential building is fine as far as zoning goes -- and tech/engineering companies routinely trade buildings with insurance companies and the like).