" I am not sure my daughter would be happy if the big activity for the weekend was floating down the Susquehanna in an inner tube."
Suggest she do some legwork to scope out what those “big activities” really are, typically.
The reality my D2 experienced at her first school was that actually “the big activity”, nearly every single weekend, consisted of going out to bars near greenwich village. Which was both expensive and,very quickly, boring. Sadly, the budget of a college student did not permit her to get tickets to “Something’s Rotten”. Given the budget of someone who is a student and not an investment banker, she found she actually had more to do, that she could afford, at the college town she subsequently transfered to.
The biggest difference was in NYC everyone lived in dorms where it was hard to socialize; high security, no room to spread out. At the subsequent school, many upperclassmen rented private apartments nearby but unaffiliated with the school. They socialzed by visting each other, off campus. No need to go out anyplace, necessarily, and waste lots of money, Often. they threw dinner parties in their apartments. Very different social scene. And they had bars there, too. If desired.