In reply to Rob Laird:
Le Ceou is a decent option, in that the camp site with pool is at the foot of the crag, plus there are rivers to swim and canoe in, there castles in the village etc.. Castelnaud la Chapelle is the place. https://www.campingmaisonneuve.com/ You can see the crag in some of the pictures.
However, it can be stinking hot, as is the way with anywhere inland in France in the summer and I have been recommended St Cirq Lapopie in the past on the basis that it is a) beautiful and b) the crags face north. There's a camp site here http://www.camping-truffiere.com/accueil-en.php One of the crags is St Gery, which looks nice (on ukc)
Looks like a contender to me, but it rather depends on the family agenda I suppose. St Cirq is also easy day trip distance from Castelnaud la Chapelle, which would give you a Plan B if le Ceou is too hot. there are smaller subsidiary crags in amongst the trees near to Le Ceou too, which do have shade.
Mountains are an option, but perhaps the family won't play nicely if you leg it to somewhere where it is not raining for a day's cragging…..
Le Ceou is close enough to the campsite for a few mornings cragging before it gets too hot, which might be more politically acceptable than a day trip.
Post edited at 11:06