Preface: DC fast-charging is "Level 3". A 240V ("clothes dryer connector" in the US) or hardwired wall-connector is "Level 2" and in the US is typically 15-50A - if you have a modern home with plenty of free 'leccy panel spots then you can do 90A. A slow 110V or low-amperage 240V (for outside North America) is considered "Level 1". The supply of DC fast chargers is not open to the public at all: only Tesla and a tiny number of third-parties maintain Level 3 infrastructure, and they all require outhouse-sized transformer units
for each car space, separate from the car-connector part.
---------
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.