Good city-based modules?

[Yair]

A lot of people like Shackled City, which focuses around the city of Cauldron, but I would imagine it's got a lot of dungeons in it.

I have only begun Shackled City, but it's definitely filled with dungeons. There is certainly some social interactions and intrigue, but ultimately unless your players are really heavy on the roleplaying or you change things substantially the thing is more a series of dungeoncrawls/missions with some investigations in between.
It's also huge.

If you're interested in political campaigns, you might want to check out Dynasties & Demagogues too (available in print too).
Yeah, I'm an Atlas Games whore

Yair