The public libraries in major cities like the New York Public Library have sizable collections. The smaller libraries in the outer suburbs have a much smaller selection. Yes, there's also inter-library loan system for the suburbs to pull from the big city library but there are restrictions such as only having 3 items at a time.
The neighborhood public libraries are wonderful resources but there can be limitations (quantity of titles) that prevent it from being a sustainable substitute for streaming for someone that wants to watch ~2 hours of content every day. My friend tried the public library and it was only a temporary reprieve from the ads on streaming platforms. The library simply didn't have enough content for her to watch.
I'd encourage anyone reading to go to your local library if you haven't been in a while. Check out a book. See if they have a makerspace. Do some remote work there. They're wonderful places. They become more and more important with every passing year.
Not many of those left in my local libraries. They downsized to popular fiction and a rack of magazines to introduce more sofas and space for charity cake stalls. And "mindful colouring-in" if you're around for the 4.5 days of the week that they're open.
Libraries threw away the one thing that made them unique, curated knowledge, in order to compete with Starbucks as a "third space".
In general library stuff is of relatively high quality and they have budgets for taking care of the collection.