In no particular order;

ROC
ITH
YUL
CHS
LEX

But in my opinion, for a good overnight, what's more important than where you are is the crew you are with. A stay at a good overnight with slam-clickers is less fun than a walk to the strip mall across the highway in Backwoods, USA with a fun crew. Oh, and as the poster above said, a good bed, no roaches or bedbugs, AC that works, etc.