---------
Level 3 / DC fast-charging is not intended for long-term and repetitive use: it's only intended for road-trips and that's it - that's because DC fast-charging is bad for your battery.
I primarily charge at home using my 90A wall-connector - but I still rate-limit the charging to ~60A to help conserve the health of my battery-pack. Not that it matters much: since Covid and WFH my driving has dropped drastically, from ~30,000mi/yr to less than 5,000mi in 2020, and less than 1,000mi so far in 2021. (I got my Model X in 2018 and it's still got under 20,000 miles on it, lol).
But you raise an excellent point about apartment complexes and parking-lots not being able to feed dozens or more charging spaces. Yes, it's a problem, and no, I don't see a viable long-term solution.
Other than apartments, cities like London, etc, have built car charger ports into streetlamps so people with street-parking can charge their car at Level 2 speeds using that pre-existing infrastructure - I'm unsure to what extent it's a public-private-partnership vs. public, but the opportunity to profit from car-charging infrastructure means pushing the cost-per-mile up above the cost of gasoline/petrol - which undermines the economic-and-environmental benefits of BEVs (especially when you consider the dreaded fuel-tax on petrol will eventually be extended to electricity if governments don't introduce usage-based road taxes). It'll be mess, methinks.
Also, everything is terrible.
How so? J1772 itself maxes out at 80A, and I don't even know of any production EVs that support that: most max out at 48A or lower. And even for Tesla's connector, the highest I've ever seen (which isn't even offered anymore) was 72A.
The wall-connector in my garage has a 90A sticker put on it by the state-licensed electrician who installed it - and I can drag the rate-limit slider in my car's UI up to (and beyond) 90A. I'd take a picture and post it to show you, but HN is famously text-only.
I'm not familiar with this field but I'd imagine this would take some special arrangement with the power companies. But so far that seems to be the only solution at the moment.
Without apartment buildings offering this I don't see how it could be widely deployed without changing how cities are built and transportation is deployed. Even if all the buildings offloaded to external Uber-style autonomous fleets they need to be charged somewhere and at a massive volume. And in my city 90% of new housin development for the last two decades seems to be on apartment buildings.