Forgot to comment on this earlier. Limsa Lominsa during the day with foggy weather; to me, that is hands down the best looking thing I've seen in the game. It's like a city floating in the clouds. It also seems to be fairly rare, as I've only ever seen it once.
A close second is the Floating City of Nym. I would pay real money to have in-game housing there.