In a lot of cases this is true - and it's not just about tech. Rural communities are often more religious, more conservative, lower income, lower educated, and have a lot less access to opportunity. Cities also mean that there's often a critical mass for many interests and minority groups. Are you LGBT? Are you a religious or racial minority? Do you have hobbies that might be more unique? Cities have the critical mass for so many groups of people.
Before I go further, I want to take a moment to talk about three things: income, education, and opportunity. Someone lacking any or all of those doesn't make them a bad person. However, moving to an area without those things can have an impact on you. In the US, a lot of services are paid for by property taxes collected by the municipality and county. If you move to an area where people are struggling, there isn't the same kind of money for services - and even if your housing is cheaper, you'll be paying a lot more in taxes since you might be going from "above average" to "really rich". Education and opportunity can also be a problem. Do you end up in an area where many have resorted to meth or opioids? Do you end up in an area where chronic unemployment is an issue? Again, this isn't people being bad or anything like that, but it can cause fear and resentment.
There was an article (which I can't find right now) about the unionization drive at an Alabama Amazon fulfillment center. Amazon came into a town that basically hadn't had jobs and everyone was living pretty poorly. The article interviewed some people and the sentiment came across as people thinking that the place was dying and even if they wanted a union, they didn't want to risk going back to a place that was a disaster.
In rural communities with flood risks, FEMA has bought and demolished properties rather than pay to rebuild them. This ends up gutting the tax base and leaves the community as a shell of itself. If the main store in your town and 5-10% of the houses get bought and demolished, you still have the roads, police, etc. to pay for with a dwindling tax base - and less reason for you to be there.
https://mtgis-portal.geo.census.gov/arcgis/apps/MapSeries/in...
Check out the census map and select "Population Change" and then zoom in one level so it shows counties. Many rural areas have lost 10-30% of their population over a decade. It isn't fun to be a part of a dwindling tax base. A lot of expenses don't go down as that tax base goes down.
Along with this, I'd argue that there's a brain/income/opportunity-drain in a lot of rural communities. People who are richer, have more education, and more access to opportunity are more likely to leave. Are you buying into a location where the future isn't on your side?
If you're thinking about the next 20-40 years of your life, I'd argue you need to think about climate change and whether the US will continue to subsidize rural life. If we're going to get serious about climate change, will that mean $10 gas? Even with electric cars, the cost will increase. Will we continue to spend a fortune on roads and other accommodations for rural life? The US spends a huge amount of money on rural telecom infrastructure our of taxes on urban areas. Will places like Amazon start differentiating shipping pricing? It's a lot cheaper for them to deliver in cities where the distance between stops is small. I don't expect anything extreme, but if things are getting 1% worse every year, that starts to add up.
All that said, I do think that there are some good rural communities in New England - Central/Western Massachusetts and Vermont especially. You'll find high educational attainment, a population that is relatively stable, access to decent towns and cities, and a liberal enough attitude that won't expect you to conform to the hegemony as much as many rural places. Many of the Western Mass towns even have municipal fiber. I think you'd find enough tech workers around.
Honestly, it's hard to say whether a place would be a good fit for you since I know almost nothing about you. Are you white, male, straight, Christian, etc.? A lot of rural places can become easier if you tick those boxes. If you don't tick those boxes, then you might start wondering how you might be treated differently from living in the city.
It's also hard to know what you mean by "rural" since the distinction between suburban and rural is hard in the US. In Europe, things drop off to farmland very quickly. In the US, things just sprawl with no clear distinction. Is Saratoga Springs, NY rural? It's certainly a bit far from things and might be the "pastoral" feeling you're looking for, but it still has stuff around. Likewise, there are plenty of locations with very few people that might be an hour from a city like Boston. Boxborough, MA is an hour from Boston while covered in forest. I'd think of it as "suburban", but it might the rural/pastoral feel you're looking for while still being within commutable distance to everything.
Maybe you're looking for a place like Saratoga Springs or Ashville, NC or Burlington, VT or Charlottesville, VA. I think those places could be really nice. I would caution about moving to an area that is seeing a lot of population decline that has a big lack of opportunity.