Think it depends on what you consider a good holiday and there are lots and lots of good holidays
Our kids are 4 and 7 and we just spent two weeks in the Dordogne with another family (their two kids are the same age as ours). We rented a farm house on top of a little hill in the middle of nowhere - well, a good drive to anywhere remotely 'busy'. Big pool, excellent kitchen, lots of space, wonderfully quite (apart from wildlife) and absolutely no interference from anyone, it was superb. I took a PS3, lots of movies and my Sonos system. We spent the days letting the kids get on with it whilst the adults created awesome meals, drank good wine, stayed up late listening to tunes, enjoyed a beautiful view of the Milky Way every night and had those rambling conversations such times engender... Stepped out a few times to visit a market, evening meal etc but spent most of the time at the farm, just too perfect to be anywhere else frankly.
Wouldn't do it every year and must be two families minimum (only takes one adult to supervise kids) but every once in a while it's nice to get away from it all. Only possible with young kids, teenagers would want more so worth considering as your kids are also young. The rental could sleep 14 and cost us £100 a night per family, can't even get a plastic mobile home on a camp site for that!