Honestly, as someone who has owned and driven an EV for the better part of a decade, L1 home charging has been sufficient most of the time. That uses the same type of 120V plug that you'd use for a coffee maker, and it's enough for about 40 miles of range while you sleep.

With a modern long-range EV, nightly L1 charging plus occasional DCFC or L2 charging would meet the driving needs of almost everyone.

So the solution is very simple: Just install L1 EVSEs everwhere. Streetlights have extra capacity now that LED bulbs are in vogue, so putting L1 charging next to every on-street parking space isn't even a technical challenge.