In my experience, most college students really just want a good space to work and study, with a mix of quiet spaces and areas for group work. Undergraduates rarely needed to access the physical books, since they're told to buy almost all the books they need for each class anyway. In 4 years, I think the only books I ever checked out were novels I was reading for pleasure, and I could have easily gotten them from the city library instead.

From an average undergrad's perspective, the ideal "library" is probably something more like a WeWork.

Grad students and researchers have different needs, though.