Thought I would wade in on this one, we have been going to CP for 8 years, have been to Whinfell, Sherwood and Elevden and we actually drive past Sherwood to get to Elveden 
We stay in the same villa each year, it has a single path to our door, no shared path with other villas and due to the angle it is more private than others. We took time out the first time we went to scout out a good villa. It means we don't have to hire bikes as we are a 5 minute walk from the villa into the centre.
My boys are now almost 10 and almost 7, they tend to want to do the same things, so tennis, badminton, bowling, horse riding, rock climbing and of course the swimming pool especially the rapids. The boys take their scooters.
We stay in a woodland lodge, I wouldn't ever recommend staying in comfort o or comfort plus. The comfort plus ones were refurbished and I use the term loosely in 2005. They just replaced melamine white tables with wooden ones and put in a DVD player, and put towels and toilet rolls in the villa, yes you really did have to provide all your own toilet rolls 
So they then did a proper refurbishment with an interior designer, hence the woodland lodge etc.
We do love CP because the children get a lot out of it. It isn't that relaxing as we are go go go but I enjoy it and I get a lot from the children enjoying it. As much as I would love relaxing on a beach my boys are too active to dig in the sand day in day out. So CPs it is.