I was just on vacation recently. I stayed at a couple different places because we were going to different cities and doing different things.
I stayed at a family members house for a couple days. I stayed in a really nice fancy hotel for a night. I stayed in a decent hotel/motel for a night. I stayed in a cheap motel near the airport the last night.
I'd have to say the fancy hotel I stayed in was the best. It was a 20 story building and we were in the 19th floor. Great view. They also had a pool on the roof of the building which was pretty neat.