A year ago or so I think I saw a mod around here that changed (some of?) the city gates to have much more detailed models instead of being just flat with parallax textures. I'm not sure if it was a req or a wip or only in my imagination, but in any case it would be awesome if it existed. (Or if someone would make it!) Would add a lot to immersion.

Just to be clear, this is the gate I hoped there was a replacement for: (Bruma's gate)
http://img541.imageshack.us/i/screenshot20t.jpg/
http://img219.imageshack.us/i/screenshot21e.jpg/
http://img180.imageshack.us/i/screenshot22x.jpg/

It really looks awful :/

Too bad the "Improved Doors" guy didn't do gates.

http://tesnexus.com/downloads/file.php?id=33003 uses meo's wooden fortification resources for Bruma's walls and gates. Those are very decent models and pretty detailed.

That's the closest thing I can think of. But it completely alters the city's layout and puts it into the Tamriel worldspace. It's a great mod, but maybe not what you're looking for. If, by any chance, you were looking for something like that as well, however, it would be a win-win!

http://tesnexus.com/downloads/images/33003-4-1279070087.jpg