I live in a walkable Seattle neighborhood. Accordingly, the "supermarkets" are not quite the mega-large stores they are in other parts of the city, and they have smaller parking lots accordingly.
This is a generalization, but as a rule, Seattle is laid out on a grid system, and every 5 blocks there is a larger 2 lane road where the speed is 25 MPH instead of 20MPH. Grocery stores are generally on the corner of those larger blocks.
> Would much rather be near a decent small or midsize grocery
In my experience, prices are higher and the selection is very limited, so living near one of those doesn't present much benefit to me.
Which is my next point, despite living walking distance to 3 grocery stores, I still typically drive a mile away to a larger store because prices there are 2/3rds to 1/2 what they are at any of the stores close to me.