LOL. We may have shared some similar experiences.
Yes, to be sure, every area has their "bad areas." There is little getting away from it, unless you want to go off the grid, and even then, is there really such a thing as going off the grid, unless you are talking about remote areas of Alaska and Canada?
If there are areas that are highly reminiscent of rural and more remote areas, but really aren't quite so, keep these places to yourself, but just know, they probably won't be so remote in a decade or so. Alaskan areas will remain rough, b/c there are many areas in which they are truly tough to live--nothing like rural-like suburbia. If you are looking for more pleasant climates, more than likely you will feel the squeeze immediately or in no time at all.
It's funny, however, when I meet people that grew up in warmer climates, like Mexico, and they move up and love the cold and snow. I think it's yet novel to them. When you are raised in it, there comes a time when the thrill of long, gray winters, slush, or walls of snow become quite tiresome. So, although Boston has some charm to it, it too becomes a bit much. There are, however, folks in the upper and outer parts of New England that come off as less condescending and self-important. Those areas would be fine areas in which to live, if one is apt to tolerate the very severe and LONG winters--certainly not like much of Alaska, but tough enough. I choose to tolerate now only abbreviated winters over terribly protracted ones.
For a number of reasons I find certain areas of Maryland, Virginia, Pennsylvania, as well as Philly a little more temperate with regard to both climates and people as compared to Boston. Certain of these areas have access to major cities for entertainment, while also being near ocean areas or other pleasant rural areas. New England is lovely, so long as you don't have to bunker down for the long, cold winters.