Besides the advice you will receive here, I would recommend that you run a search for "Cancun" at the various FT hotel forums. Tripadvisor will also have a lot of reviews.

I've only stayed at the Hilton. It's a terrific property but it's located in a more quiet area of the hotel zone. You can always take the hotel zone bus to where the action is. The bus costs less than a dollar each way and there seems to be a bus running every 5 to 10 minutes. The bus runs 24/7. The locations along the hotel strip are designated by a kilometer number. The Hilton is located at 17km and the area with most of the nightlife is closer to the 9km or 10km mark.