My D attended Bates. She never had a car and never felt she needed one. Some friends had cars, and by the time she was an upperclassman, they would have excursions occasionally. The college provided frequent shuttle buses to Portland and nearby areas in Maine, and I think there was a shuttle every couple of weeks to Boston for day trips. The college also offered plenty of excursions, and various clubs provided their own transport. For example, she participated in debate and they went as a team to various other colleges for competitions.
Getting home wasn’t a problem. For the first couple of years, she went to and from college via coaches and planes, then a couple of friends had cars and they carpooled.
D had a friend from Florida. She drove an enormous red pickup truck. She just loved driving and took a lot of road trips. She did have a tough time finding parking sometimes, as her car was so big. Some college towns have overly zealous parking enforcement around the college and kids at Bates got parking tickets pretty regularly. Some colleges have more limited parking options, but others, such as the college my son attended, have enormous parking lots that are miles from campus, which is not very convenient.
I think a lot of colleges provide plenty of transport options. My son attended Binghamton (not an LAC) and took his car his second year. He really didn’t need it, tbh. The college had a bus that went all around town and even though he had a car, he still used the bus regularly, especially if there was a group and some, ahem, underage activities going on, when he wouldn’t drive.
My good friend’s son is at Colorado College. He took his car with him for his second year. He wants to ski at the weekend and found the bus schedule inconvenient. I’m not sure if CC has a car culture, but I believe he is the only one with a car in his group of friends.