Libraries where good for before the XXI century. Nowadays the amount of content they had is pretty small. Most libraries don't really has anything but the more famous books.
We got a nationwide network of specific books. You can order books to your local library if you are a little patient. They might not have a lot of selfpublished books but that is a problem of scale and negotiating power of publishers.
That's pretty sweet! I grew up in an area with a county system, so you could get books from anywhere in the system (a dozen or so citires serving >1M people).
My current library is just our city, but I can go to a few other cities to check out books, but I can't use holds there unless I pay $2-3/item to have it delivered to my library. We have a statewide ebook/audiobook network (serves 3-4M people), so that's nice.