There is a middle ground, I think.
I like individual houses with gardens (most people do, I think) with a size such that convenience stores are viable and reacheable on foot. It's like that in my area (England): good size houses but it's dense enough that I can walk to 2-3 different convenience stores when I need a few things, with a Post Office counter in one of those stores.
In Europe there are also plenty of small scale 'appartment buildings', say 3 to 5 floors surrounded by some greenery and a small carpark, which I think works well, too. A random example in France (near a world famous tourist site): https://goo.gl/maps/avKMYuRAfgxq3gvM9 (that area is also built around a big shopping centre, which is therefore within walking distance).
The bigger it gets the higher the likelihood that it becomes shit.