That's a rosy picture of what a library is supposed to be. In my experiences they are places parents send their kids for free after-school day care, where homeless people go to get out of the heat, or where people who don't have a computer go to use the internet. Bibliophiles definitely use them, but they don't hang out there and socialize with like-minded people.
I don't know where you live, but I've had a lot of good luck finding nice libraries. When I spent a summer working in NYC, the SIBL library was just awesome in terms of facilities, hermann miller chairs, etc.