Back in Nov we stayed at the Holiday Inn Resort - Waterpark. It was a partner hotel of Discovery Cove at that time. Now I think its going to be Official Partner status in the summer.
When we went, we booked through Discovery Cove (Sea world's day spa). Note: you didn't need to buy Discovery Cove tickets to just book a room.
anyway....it used to be the Nickelodeon Hotel and Water Park. Holiday Inn bought it and refurbed the entire thing. Really nice rooms for a family.
Ours was a 2 bedroom suite (king in one room and bunks inthe other).
We did 5 days (5th was free) and it came to $350....that included priority seating to SW and the other things as well.
Might be worthwhile to take a look.
2 negatives -
1) kitchenette area is small....no stove/oven so cooking is limited to microwave.
2) shuttle to SW was limited (once or twice in the morn, 3? times at night) - this might change once the partner status is upgraded.