I've always found the City of Splendors guide to Waterdeep (Forgotten Realms) as an excellent example of a thematic city-based sourcebook. Not only was it dense with crunchy material and pretty art, it contains some very good writing that brought a fantasy city to life.