My hometown library was quiet all the time in the 80s, but it was also basically one really large room and any noise carried really well so they enforced quiet. The state college library was similar, and enforced quiet when I went in the 90s because people were studying.

Most libraries in the movies are also large, open spaces and like everything else they play up the extremes or the writer's experiences. Since movies tend to stick with stereotypes, so don't expect a library scene in a movie without someone being hushed any time soon.