Can’t answer many of your questions but I’ll comment on these. My kid never had a car at CC and had no issues. You can bike or walk to the downtown area.
For ski trips, there are busses going from campus to ski resorts during many weekends and block breaks during ski season. Or students go with friends with cars.
I never heard my child complain about being bored or having nothing to do in 4 years.