I can tell you about a few of these schools.
My daughter goes to Bates and does not have a car, but many of her friends do, and she catches rides with them (and, yes, fills their tanks every so often). There is a college shuttle that can take students around Lewiston/Auburn – to various stops including big box stores, etc., and that works pretty well (my daughter took it to and from her volunteer job last semester, and for Target runs, etc.). I think there has been, in the past, college-sponsored shuttles to the transportation center and airport in Portland, but I think those fell victim to budget cuts – hopefully they will be back. There is also a bus that leaves campus a couple of times a day for Boston Logan. If your kid goes to Bates, the parent Facebook chat will give you suggestions for a couple of highly trusted cab services that serve Portland, and we’ve used those a few times, too. My daughter would certainly like to have a car, but her existing car is on its last legs (definitely not safe to drive it from Colorado to Maine and back!), a new one will be too expensive (for us and her), and in the meantime, she can survive without it.
We’ve visited Vassar, Conn College, Wesleyan, Oxy, Skidmore, and the Claremont schools. All but Conn College and Skidmore are accessible to a walkable town or public transportation. If memory serves, Skidmore is not far from downtown Saratoga Springs, but it would be a bit of a hike on foot (I could be wrong) – I don’t know if they provide shuttles. With Conn College, you would have to Uber (or something) to New London, and the school does provide vouchers (a few per month). I grew up in LA, and of course anyone in SoCal would want a car, but Oxy and the Claremont schools are workable without one – between public transportation and friends with cars, a student without one should be fine.
I’ve lived in Connecticut, and I loved exploring the area (did a lot of hiking, for example), for which I needed a car. However – that was after college, so my needs were different. I think that for the kinds of outings college students are likely to go on, campus shuttles and public transportation will be all they’ll need.
I have not visited Macalester, but I know you really don’t need a car there – light rail is right there, and there’s a walkable restaurant/retail neighborhood nearby.
So look at campus parking policies (often, first-years cannot have cars), and look at campus transportation assistance (school-sponsored shuttles, vouchers, etc.), and typical transportation choices to and from airports and bus/train stations.