Many years ago, when I was in elementary school (so we're talking almost 20 years now), I went to Sea World daycamps and overnight camps every summer. They may have different programs these days, but I /always/ enjoyed them.
At least from my experience (of around 20 years ago), the most fun were the sleepover camps. They usually involved educational games and projects during the day, along with the chance to go through the parks and also see backstage areas... then you'd break out the sleeping bags inside one of the exhibits (when I did them, they offered them at the Manatees, Penguins, and I even once did a sleepover at the "Dino Marsh" or whatever that they had briefly).
I can't say for certain that things are the same as they were then, but from my own experiences as a science-minded kid, I think they were well worth it!
=)