I share your feelings. I love the idea of a good city supplement, but that actual ones I've come across tend to be too static, gigantic lore dumps, or (some of the older ones) just a bunch of generic encounter tables.
I really like Hyena Child by Gazer Press, though. It details 17th century...