I agree that Esthar is probably the most conspicuous city in any FF thanks to the amazing design of it and the ambience created.

But my favourite is Junon from vii with the way that the sister ray dominates the background. I also love the way turrets appeared during the weapon attack sequence. The military feel of the city just gave it an originality and many of the best parts of the game took place there.