I lived in an extremely small town in Kansas for two years.
I'm generally one of the "blooms where planted" types, but that place was tough. I was single, and most of the people in town were either married or had taken vows of chastity. I was content to be single, but it did get a little old to feel like the third wheel most of the time. The good news is that I finished my dissertation, and had several conference papers accepted, as well as one article. I gained some valuable teaching experience beyond the intro level. Amazon and Netflix went there, and even the worst locations have at least one edible restaurant. Or restaurant with edible food. Take your pick.
That said, I couldn't drink the water. Literally. I bought the water that I drank and cooked with at the grocery store. It wasn't that it tasted bad, although it did. My body had a particular reaction to the water, even after running through a filter, and until I figured out that the tap water was causing it, I thought that I must have some kind of dire gastrointestinal disorder.
I'm glad to be elsewhere now, and there were times when I found myself wondering if anyone would even notice if I were to lay down and die. I took a $3K cut in pay (which was nearly 10% of my salary at the time) in order to take a job somewhere else. It was worth every penny.
There is one small town in Kansas that has a college in it, and I don't know if we're talking about the same small town, but this one is surrounded by giant hills of mine tailings. E Coli would be the least of my worries if I drank the water there.