"Aside from the hostiles..." would be a great starter for pretty much any post in this thread. xD

Hmm. Tough call, really. There are some really lovely places in the various Final Fantasy games. My ideal place to go would not be a major tourist hot spot, but still have everything a tourist would want. So I'll have to avoid Costa del Sol / Wonder Square for that reason, otherwise I'd possibly agree with Murd. I always prefer to have at least a little bit of greenery where I go, too, which also possibly counts against that location. Hmm... I'll pick a few locations for different types of holiday.

City Break: Esthar, FFVIII. I mean, this place is insanely advanced, but doesn't have the slums that most insanely advanced places have (at least, not that I know of) and also doesn't come across as too snobby.
Tourist Break: Somewhere with ruins. Cyrodiil ([jiro]got yer back[/jiro]) of Oblivion sounds nice, there are an endless number of pretty ruins there. I love ruins. =]
Relaxation Break: Somewhere really lush and green, but still with the technology to keep me going. Perhaps somewhere on Spira, there were some really pretty locations there.
Oh Man This Is Some Crazy tit Check It Out Break: Somewhere to do with the Myst series.
Cheap/Short Break: Balamb always struck me as a really nice place to go to, with the music and the small fishing town feel to it. Fishing towns always have good food available, and there looked to be enough sun and enough of a relaxed nature for me to enjoy a stay there.
Sun/Beach Break: Okay, I'll cave and put in Costa del Sol anyway. =]