We have been to this site in the Dordogne area 3 times with our caravan, it also allows camping - our DC were 9 and 11 on first visit but would happily still join us there at 19 and 21. I think it is our favourite site/area in France.
Always had good weather, usually arriving towards end of July, leaving mid- August. Occasional thunderstorm but still very warm.
bel-ombrage.com
It’s a short drive to the Dordogne river near Castelnaud village, it also a shallow river on site with a “pool”/beach area for paddling and splashing in, and onsite swimming pools.
Quiet site even in summer (no on-site entertainment etc). An Italian within walking distance plus plenty of food outlets in Castelnaud village and other local towns/villages. Bakery van on site in mornings for Croissants etc.
Some lovely things to do in area including Beynac, Domme, Sarlat, river activities, La Roque-Gageac, further afield Rocamadour and various caves.
Domme is a great place to potter around and to get a spectacular view of the river, as it is set high above it– and does amazing ice creams!
Les Jardins de Marqueyssac sit high above the river opposite Castelnaud and are beautiful at any time, but they also do candlelit evenings every Thursday in July and August. It has music playing, food outlets, beautiful sunset views - I actually think the evening visits to the Gardens were my favourite part of our trips to the area!!
We have generally crossed on the tunnel, driven to and around Paris, done an overnight in the Blois area of the Loire, southwest of Paris, then carried on south. Bearing in mind we were towing a caravan, which you won’t be, then it is easily reached in a day from Paris area.