Google Scholar has greatly reduced the benefit of having access to a college library.

That depends on the field. Some fields are so riddled with paywalls that Google Scholar is all but useless; others like computer science, are much more progressive.