A new survey from Which? of more than 6,000 people has ranked the best and worst hotel chains - with some surprising results.