I just moved to a new, big building in SF that has literally all of these things. This is the new market rate housing that Yimby groups are fighting for in citi

I just moved to a new, big building in SF that has literally all of these things. This is the new market rate housing that Yimby groups are fighting for in cities, it's being built. At least part of the issue is a chicken and egg type problem. Older city housing stock mostly does not meet your criteria (or it does but costs several millions of dollars and has no density), so people oppose dense urban housing, so it doesn't get built, so we never get to see how it actually can meet the criteria people care about.