That should be B9/B327, see openstreetmap.
The building in the picture is Parkstraße 22 and apparently in use for sports purposes, as this Facebook posts invites refugees to gather there for sports
You should read Suburban Nation: The Rise of Sprawl and the Decline of the American Dream. You very cogently touched on a lot of the social issues that arise out of traditional suburban development. For me this book was like a religious experience, putting words and names to things I have long felt but never described.
Yeah the prototypical bike-friendly city of Houten (outside Utrecht) has exactly this. For pedestrians and cyclists it's a permeable grid, for cars it's all cul-de-sacs. To drive to someone 100m away may take in a convoluted route back to the main ring road and in again, but to walk or cycle the same connection will be much simpler.
Works really well I think. I wish this model was everywhere
https://www.openstreetmap.org/?mlat=52.083333&mlon=5.116667&zoom=12#map=15/52.0325/5.1679
This is the Bell Centre, the largest hockey arena in the world and also one of the busiest.
It has zero surface parking. Zero.
It has some underground parking, but most people get there by metro, train, bus, or on foot. Conveniently, the arena is built directly on top of - and connected to - a metro station, bus terminal, and train station.
Houston chose another path, and now it has giant parking lots in its downtown.
I think some of it also has to do how suburban developments are built to a "final state". As detailed in Strong Towns: A Bottom-Up Revolution to Rebuild American Prosperity, homes are all built around the same time, of similar styles with no expectation of change. Because of this, homes also deteriorate at similar rates, causing the entire neighborhood to look tired. When repairing your home, the impetus for many is "keeping up the Joneses". If all of your neighbor's homes need repair, then the neighborhood must be in decline. Why would I invest in a dying neighborhood?
Those who have the means, leave the neighborhood for a shiny new development, creating new rings of suburbs. Those who don't are stuck in a neighborhood that people no longer invest in, with zoning that eliminates the possibility of new uses, like multi-family housing or mixed-use development.
The cycle continues.
This has already been thought up, and in a much more comprehensive way. Unfortunately, because of lots of reasons (like the lack of a land value tax for one and car-centered transit policies for another) all of them are unlikely to ever see the light of day without concerted citizen action.
See: Sprawl Repair Manual
https://www.amazon.com/Sprawl-Repair-Manual-Galina-Tachieva/dp/1597267325
Here's the full title of the urban version. It's kinda hard to find, though. https://www.amazon.nl/f%C3%A4llt-steht-droht-derBaggerzahn-Ver%C3%A4nderung/dp/379411499X
My fave book as a kid would be the /r/UrbanHell version of this post.
This was one of my favorite books as a kid. It's story fits that line perfectly.