1. We're spending one night at Castaway Bay (for the indoor water park). Anyone ever been there and if so, how was it?
Never been there, sorry, can't comment on it
2. DS 11 is not a coaster nut so DH and I will probably be switching off between boys. Is there enough non-coaster rides to keep DS 11 busy?
Plenty to keep him busy, there are a lot of smaller carnival-type rides that spin and loop, etc. One of my faves that is not a coaster is the Witches Wheel near the back of the park. You have no restraints whatsoever, you are just put in this little cage-like contraption, it goes upside down but the centripical force keeps you in your seat - so cool! Also there are some not-so-huge coasters for the less adventurous too, such as the Wildcat and even the old standby - Blue Streak!
3. Is the park food really that bad? Can we merrily snack our way through the parks and be happy? Is there a nice selection of places to eat other than TGI Fridays off of park property?
Yeah the food isnt that good, and you pay quite a bit for it too. Back in the day we used to bring our own food in a cooler and eat at the picnic tables. I dont know if you can still bring in food or not. Our thing was we would eat our own food for lunch, and "splurge" on the cardboard pizza for dinner...
4. Have heard a lot about Put In Bay being a huge party spot. It is family friendly at all - could we bring kids for the day and would there be stuff that we could do or would that just be a bad idea?
I know of a lot of people that have really loved the area. Personally, have never been there but have heard very good things!