I wish we could get some numbers on this, as I've lived in the same spread of places as you and I agree with the GP. I'd be happy to be proven wrong.

The sustainable rural community is exceedingly rare - most are propped up by ag subsidies and state aid. For much of the central part of America, there's no housing benefit or tourism to speak of, just resources (corn/soy in general, maybe livestock).