I've been to Cabo 3 times, and stayed at different hotels each time. Casa Dorada is definitely the nicest of the hotels I have stayed at in Cabo. It's very modern and beautiful. The rooms are clean, large, and very nice. The hotel itself is in the best location of Cabo -- you go out of the hotel, right onto the sand, and you're in the heart of everything -- all the bars and all of the water activities.
It is definitely pricey for Cabo, but if your budget allows for it, I would highly recommend . . .