Vornheim might be worth investigating; don't have it myself, but have heard good things.
I heartily recommend Magical Medieval Society: Western Europe, a 2003 Ennie winner. It has a decent random neighborhood/ward generator, quite a lot on guilds and power structures, and goes into some detail on fees and resource rights that can provide plot points.
It's not bad, but personally I found it kinda banal and obvious, most of the time. It had some neat-o city maps, at least.WotC produced a fun book on the subject called Cityscape for 3.5. Might be worth checking out.

(Dungeons & Dragons)
Rulebook featuring "high magic" options, including a host of new spells.