Perhaps the greatest library and librarian scene in Hollywood films is the
Thatcher Library sequence from _Citizen Kane_, in which the reporter goes
to read the memoires of Kane's foster father.
Other films with library scenes:
Cary Grant gets alcohol poured down his throat in a mansion's private
library early in _North By Northwest_.
While we are on the subject of Hitchcock, Charlie figures out how evil her
uncle by reading newspapers in the Santa Rosa public library in _Shadow of a
doubt_.  I'm fairly certain the library sequence involved a librarian.
I may well think of more later.
-- Ben Alpers