There is not a 1:1 correspondence but what you describe is actually how many of us in Europe choose to live. It is not a fantasy, it is happening.
To be fair our current lifestyle in Europe is not sustainable either, and on different scales we face the same questions as you pose.
This is a YT channel that I appreciate relevant to the topic. It's created by an American who moved to Holland and examines issues of urban planning.