If you're looking for waterparks...
My family has been to Kalahari, Great Wolf, Wilderness and Chula Vista a number of times. Kalahari is the family fave, with Wilderness a close second. (We've only visited Mt. Olympus during the day, and I don't think I would stay there with the other alternatives in the area.) As other reviews have stated, Great Wolf and Chula Vista are both also very nice, just smaller.
All of the 'big 4' have very nice 'condos', which are like houses/townhouses that you could have your family stay in so they are close together. One consideration for the Wilderness is that the waterparks are in different buildings. You may be able to walk between them in June, but usually you just take a shuttle, and you have to pick the one you want to go to.
We have stayed at the Kalahari 'condos' with our extended family on a few occasions, with people ranging from 1 to 60-something. The 'condos' are actually houses - NICE houses. They have ~5 bedrooms/4 bathrooms, a bar, a movie watching area in the basement (with a large screen and big, individual recliners), a pool table, a hot tub, a large deck, etc. What we really like about them is that they are big enough that the family can do different things in different parts of the house. Ex. you can have 'grown-up' activities (pool / card games, etc) in the basement while the kids play or watch television upstairs. The kitchens are also full size and well-equipped. We usually have each family responsible for one/two meals, which works out well to avoid eating hotel food for your entire trip. (There is a WalMart about 2 exits north on the interstate in case you forgot anything.)
You do have to take a shuttle to the waterpark area, but they are fairly quick and the waterparks are in one location (other than a pool at a different building).
Otherwise, the Kalahari also has a large indoor theme park, a movie theater, and a restaurant attached to the main building. (Another reviewer had said that the indoor theme park is small, but if it's small, I'm dying to see what a big one looks like!) :) The theme park has a go-kart track, a climbing wall, and 3-story ropes course and a little kids' ropes course, laser tag, kiddie bumper boats, a ferris wheel, a carousel, a 5D interactive shooting game, a race car game, and about a million other games. If you really want to do the rides, I would suggest buying an all-day wrist-band. It's usually ~$25, but it only takes a few different rides to come out ahead on the price vs. a pay-as-you-go card.
Good luck with wherever you decide to stay!!