The nicest hotels are probably ones I can't afford. From what I've seen on walkthroughs, Idle Awhile is very nice as is Charela.

I also hear that Sandy Haven is very nice, but very expensive.