We live under 2hrs away and love coming here for weekends out-of-season. Very friendly, smiley staff (grumpy looking security guard aside ;)). The water park is amazing - our kids love it. In June and September there's virtually no one there so we pretty much have the whole thing to ourselves.
It is out of the way (6km to the beach and anything interesting) but we go for the water park and everything you need is on-site. We aren't really beach people anyway. I'd imagine if you stayed any longer than a weekend, the location may be a bit annoying.
Pitches are big and grassy, excellent sanitaires, and the food in the restaurant is yum. I'd imagine it'd be packed and horrible in high season, but if you are able to go as a family outside of July and August, then I can't recommend it highly enough!