I live in a 50K-population city adjoining Boston, so they exist, I just don't know how well they exist independent of bigger cities.
I live a few miles from pavement, so I definitely need a car to go anywhere. But I don't need to go anywhere on a normal day. I go to the nearest city about 3-4 times per month.
I do take advantage of UPS deliveries a lot, but I could do without if I were more patient.
I've set up my life to not need a daily commute, but I haven't taken the car out of it. If I tried harder, I could probably go without the car, but I don't think that would be healthy (Amazon Pantry options are lackluster last I looked).
To reiterate, I'm not even close to a paved road, let alone a grocery store or city, and I can manage not to drive very often. Seems like you could too, if you made it your focus. But we've all gotten used to living a few minutes from this and that and so we have to go do something, in our car, nearly every day.
Here in Ithaca NY, the property market (relative to income) is ungodly expensive, because most people either bought their houses decades ago when they were affordable, or they're college students who will pay any price in rent to get their quality education.
Some people commute in from as far away as Syracuse or even Pennsylvania. Property prices are much more affordable 15 minutes drive in any direction, but no college professor or staff would want their kids going to any of the crackerjack rural schools.
Can't say I speak for the Midwest, so it could be different there.