The connection part is tough. I'm moving back to a major city because I found living in a small town for the past couple of years to be mind-numbingly boring.
Yeah it’s not great depending on who your neighbours are. I think better transportation and better VR will be necessary if you want the option of living anywhere. Until then finding a town that has a thriving scene that you’re into is the only option.