We love the Sleep Inn. Very nice, clean, and yummy continental breakfast. The trailer parking isn't phenomenal, but we've only had to separate the rigs a few times over the years.
I would possibly take a Springbar tent with a nice airbed over a hotel anytime, except in the middle of the summer in Moab when you sweat more than sleep.
I find that you don't spend much time in a hotel room so anywhere you have a shower is good. In the summer, you need A/C but if its not too hot, the Riverside Oasis campground has been really nice.
Id probably stay in a cabin if they have a/c. Ive stayed in almost every hotel there and never had much luck finding a quiet one. Ive been told if you have a group to rent a condo, cost same as hotel rooms if you need four or five rooms and you get a kitchen besides.