The water park was my kids DS 10, DD 8 favorite part of the trip. They loved Castaway Cay and thought the stingray adventure was alright but absolutely loved Aqua Adventure. My DD 8 even did the drop of fear.
We went the Comfort Suites route and only paid a total of around $210.00 for all four of us. We used the AAA discount and got a room at Comfort Suites for $176.00 but we made our reservation far in advance.
I am very glad we went that route and found out about it from this board. I personally would not pass it up and no way would I take my kids there to see it. It would have broke my heart to tell them no after they saw it. I have no issue telling them no but I do not wave things in front of them and then pull it away.