We went to Sherwood 3 years ago and had a great time. DD is ASD/ADHD and needs some semblence of a routine (which we had only partly realised at the time) and self-catering with plenty of activities suited us soooo well. I was back on a bike for the first time in years (have since bought a new one at home). We had planned to go out into Nottingham a few days and do different things, as we both thought we'd go stir-crazy "locked up" on site all week - we didn't go back for the car after unloading at the start until we were reloading at the end of the week!
We had brought a reasonable amount of food with us for the week - about 3 dinners and plenty of breakfast, lunch and snack stuff (and G&T). We ate mostly at home but out for a few coffees, 1 lunch and a few dinners. We did bring home food, and we did buy a few things on-site.
We swam every day, cycled LOTS every day, did a few activities (canoeing together, DD went to kids club twice by choice, one wet afternoon playing arcade games). But we cycled in the rain (had brought raingear), stomped in our wellies on molehills, looked at loads of squirrels, did the nature trail (3 times) and relaxed in the chalet as well reading and playing cards and other games as a family.
It was soo much better than SC hols I had to endure as a kid (single house in the middle of nowhere and no eating out as there were too many of us and no activities either locally, not even safe enough to cycle around, the very odd trip to the beach in 3 weeks). We ALL relaxed, we all got lots of fresh air and exercise, we got to enjoy cooking together for a change. It wasn't the cheapest, but it wasn't as expensive as some other options and it suited our family.
2 years ago we went SC in Ireland again - ugh. Cold wet and miserable.
Last year we went to the USA (as cheap as other options we looked at, as we are only 3), but SC wasn't really an option so we shared a room with DD for 10 days in 2 different hotels, with a coffee maker but otherwise having to eat in either hotel restaurant or outside the hotel. Fresh food was hard to find (we love our fruit and relatively healthy meals so a diet of lots of "X and chips" is not the greatest), and it felt far more commercialised there. The hotel pool was always crowded and the weather was not great.
We are going back to CP this year (Longleat) by popular demand. DD hasn't stopped asking since we were there before and we know that the routine part is more important to her (that we can set a routine for the week and do things like having a brekkie like at home, and doing things to our own schedule). And we enjoyed it too. We will bring DH and DD's bikes with us (as he has a "trailgator" for hers) and they can decide to be solo or joined as suits. I will rent one (less to transport). It works well for us.