Another solution is robotaxis. If ridehailing becomes easily affordable You will have your nice neighborhood back. Robotaxis can pick you up in a minute and go to park and recharge in some distant multi story parking.
If you have an area dense enough to have reliable uber then perhaps it works, but uber (and taxis in general) fall down with families with young children - the kind of people buying low density housing being suggested
That is a science fiction fantasy, not something we can plan on in any reasonable time frame.