For diving? Food? Nightlife? Anything in particular?
As for diving, I've only dove off SMB but we are going back this winter to do more in the West Bay area and the East End. I thought the canyons we did off SMB were the best dive, and I have a number of friends who love the sand chutes next to the Kittewake.
The only nightlife we did was Rock and Roll Bingo at Lone Star Bar and Grill which was a lot of fun. As for food, I love love love the happy hour at Ortanique (ceviche spoons ughhhhh), the fish tacos and blueberry pancakes at Sunshine Grill, and the conch sample at Cracked Conch/Macabuca. The rest was good, but not notable. We also did the Sunday champagne brunch at Luca which was expensive ($50 Cayman two years ago) but great food and endless prosecco.
We tried to do the beach thing at the Royal Palm and it was a zoo, so we won't be going back. We liked the public beach up by Calico Jacks the best. We tried to find a spot further south but since the beachfront is privately owned by the property owners except for a certain area from high tide, we were always baking in the sun and it was just too hot.