There are a few problems, Zoning is probably the least of the problems in the sense that we could effectively waive a magic wand and solve it, but it is a political problem which makes it more difficult than it needs to be.

One reservation I have is what zoning we get rid of and where. Many cities such as Columbus where I live have fantastic, medium-density neighborhoods that we really shouldn't touch. On the other hand the downtown area is full of surface parking lots that are not only empty most of the time in the evenings but post-COVID empty most of the time all of the time. Something I'd advocate for in a 1-2 punch would be to remove parking minimums city-wide but also to remove zoning restrictions in the downtown core first to create density there where we lack it before we try and remove it in our neighborhoods that we know are good and appropriately dense to start with.

Most of the density/zoning problems as they relate to neighborhoods exist in the suburbs, not cities.

You're right about the office renovation though too. That's an issue. Thankfully those buildings are owned by someone who, frankly, has to spend the money to do something useful with them. We should make/let them solve their own problem there because whatever they solve for will be good for downtown cores.

Unfortunately zoning is going to become a political nightmare. Already state governments in locations such as Ohio where I live are now working to block cities from slowing down traffic or providing alternate means of transportation options instead of the car-only (the government says you aren't allowed to do anything but drive a car) infrastructure we pay for now.