We just got back from the 2-25 Magic. We decided to book with Disney because we had never been to Grand Cayman before and did not want to have too much responsibilty.
We booked the stingray and rum point beach excursion. It was too windy and waves were over 6 feet, so the stingray portion was cancelled. We were refunded and spent the day at Rum point.
AFter a 15 minute bus ride, then a 45 minute boat ride we got to Rum point. It was nice. Drinks are outrageous. The water was warm. What I did not like is that we did not get back to the pier until 350 when the last tender left at 5. You go to Rum point on a boat and you leave when it leaves. We made it back, but had little opportunity to shop or walk around. I was hoping to stop in to Senor Frogs for just one drink.
If you want to go the beach I hear that 7 mile beach is just as nice and much closer. I would not go to Rum Point again, too much travel time to get there.