This is really two questions. Isolation of the campus and how hard it is to come home.
I went to a small college in the middle of nowhere, literally, but the drive home was only 3 hours. There was also a train or bus.
In contrast, for D1, getting from our New England metro area to one of those Midwest colleges, would have meant TSA, flight to Chicago, transfer flight to that city, 45 min bus ride to town, then something to campus. Probably even harder to get home, considering getting back to that state airport in time to make it all work.
So look at the real transpo situation.
If a campus is active enough- and Midd, Dart, Williams, Hamilton. Skidmore, Bates, etc, are, you don’t always need the off campus diversions. It can be nice to be near a take-out restaurant or coffee shop, but it isn’t always vital to be.