We have been to Kempervennen and liked it very much. It was our first CP experience, and we have since been to the newer one near Paris.
We thought it was great for older kids (mine were 12 and 14 at the time), and great for toddlers/young children (mine were 7 and 4). However, the in between age wasn't as well catered for - my DD aged 9 was too old for the kids activities and too young for the sports.
What we did with our little ones was to book them into the club about 3 times. They have these clubs called 'Wannabe' - what I want to be when I grow up, and then do activities and crafts around a specific them, eg farmer, circus performer. We also went to the children's entertainment that took place in the late afternoons - bingo etc.
There was also the Aquadome, playgrounds, beach, cycling around the park, and eating.
The accommodation was very spacious and comfortable, so we could stay in if we wanted to.
My older kids and hubby made full use of skiing (snow and water), and other sporty things.