I have done a lot of architecture... mostly technical archtectuere (data centers, dense corp HQs (goog, FB, Salesforce, Brocade, etc...) and a shit ton of medical (SF General, El Camino, Sequoia, Nome, and many others)

And I have worked in a few foreign cities (Singapore, Hong Kong, etc)

To me; Singapore is the most amazing city. But here is my takeaway from all of that WRT zoning:

There should be no commercial property or residential high-rise that does not have the following:

Every building should incorporate underground parking, and no residential building should have tenants on the ground floor and at ground level, there should be commercial space (bakeries, shops, etc.) But every building project should include parking and commercial space.

Zoning should be much more both maleable and specific at the same time.

It doesnt make sense off the cuff, but the thing is that zoning should be PER PROPERTY + ENVIRONMENT + NEED + COMMUNITY - REGULATION - NIMBYism