I, for one, miss rural life (wide open space, less traffic, mom and pop stores, etc.) but unfortunately my career as a programmer doesn't cater to that lifestyle all that well.
So it can help, but you eventually feel like a fish out of water when nearly nobody you know understands what it is you do. I feel like we'll get there one day in the USA, paying under $1000 for rent for a comfortable home is a lifestyle I wish i could see more technical people adopt.
If you answered yes to these questions, you're not going to find many places rural America that satisfy your needs. At best you'll end up in an outer-exurbia like greater Atlanta.
I don't think remote work of a few well-paid professionals is a viable and sustainable solution for rural America.
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.
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.
I grew up on island in Alaska. Completed my last two years of high school in a small farming community in North Carolina. Joined the military and after ten years separated from southern Turkey, yet, somehow I was able to land a job as a data scientist.
I joined the military due to a lack of academic discipline though I still was accepted to the state schools in North Carolina, just choose otherwise. I have friends who did the same, though one did attend Chapel Hill on academic scholarship he received while graduating in Alaska. I have another friend who is now an anesthesiologist who graduated from University of Washington's medical school.
A few remote workers will do wonders for rural America in the short and long term. Saying you need to live in a major city to be successful is hogwash.
I'm married and have children - but we homeschool them, so the quality of the local schools is not a limiting factor.
Healthcare is not nearly so different even in very rural areas as you've made it out to be, especially not when you have a tech salary to enable you to travel to a teaching hospital if the need arises. If anything, regular/preventive care is less expensive and higher quality with a rural family doctor.
Uber and Lyft don't even make sense in a rural setting.
My professional network is already spread across the country, so that's not really an issue. I plan to spend more time and money on travel for conferences and such.
The only things we're really giving up are faster Internet access (we'll have 300Mb for ~$100/m, instead of 1Gb included in our rent) and food delivery services (which are too expensive to be using as much as we are, anyhow).
You really need to fix the basic underlying economic issues, so that you don't have kids coming to school hungry, and you don't have the best and brightest of the community fleeing so they can find work.
The problem is that public education is public and so it runs into various forms of ideological resistance on that basis. Worse, the power of local districts to shape educational policy leads to predictable deficits, often also driven by ideology/politics.
We have the money, we just choose to spend it on healthcare inflation, and weapons to sell. We don't see an immediate profit in education, so it's sidelined or privatized. We are shortsighted idiots, as a species.