We did not stay there, but when our cruise stopped there we hopped a taxi and went to explore. I can tell you the view from the cruise ship would have been enough. The whole place was a let down, but maybe because I expected it to be updated and gorgeous. It was dated and smelled bad :(.
We did NOT do the aquarium or the water park, but I imagine those might make up for the let down we got walking through the place. Overall, we want to avoid the Bahama's in all of our future ventures all together, but maybe that's just my family.
Either way - you're going to an island where it's warm!! Even though I don't really WANT to go back, I'd trade you places!