We stayed at the lodge, and received complimentary waterpark passes (with our groupon). Our kids are 14 and 11. The 14yo got bored after about 4 hours, but the 11yo played all day. I would guess the "ideal" age is about 6-12. It's small enough so you can see the kids at almost any activity and i didn't feel like i had to follow them around (both are strong swimmers). There is only 1 large tube slide - which surprisingly didn't have long lines. Overall, nice clean waterpark. Food is available, towel are provided. We got there early in the morning, so we managed to get a couple of lounger chairs.
If you own or manage Cascades Indoor Waterpark, register now for free tools to enhance your listing, attract new reviews, and respond to reviewers.