I think Vancouver is on the list. I remember actually attending the opening ceremonies for the central branch of the Vancouver Public Library, when I was in elementary school. The building is rather elegant, I think, and they have a good selection.
Oxford obviously counts, though only from the perspective of students. The same may be true of Toronto. How is the public library system there? I am sure U of T has good libraries, even if one looks like a gigantic concrete turkey.
The reading room of the New York Public Library is one of the most appealing spaces I have ever read in, plus it is free and their archives are gigantic.
Ottawa’s central public library, on Metcalfe, doesn’t have either the physical attractiveness or the comprehensive catalogue of some of those other offerings. Perhaps that is something Ottawa should change, particularly given the number of people here who try to stay well read on their topics of personal expertise. It would add a lot more to the city than some new suburban road or sports venue might.
A better library would also be a nice place to meet bookish people.