Errrmmmmm...... No. I'm not convinced by the Loire.
We've just come back. The countryside is boring. IMHO. And the Loire is huge. So you would need to pick your area.
We stayed near Montrichard. Lovely quiet village, with a little beach on the river (you can't swim in the river, just paddle. Take flip flops as it's stony in the water). The campsite looked fine and 10 mins walk from beach, small playground and caff. Also adjacent to a handy Carrefour. But the surrounding countryside is deffinitely dull.
The chateaux are varied. Chenonceau is expensive in comparison to others, 14 euros per person including an Ipod tour. We didn't do it because the pound is so week, we were counting every penny. And there's nothing free for visitors. I know it's supposed to be one of the best but it left me cold.
On the other hand, the gardens at Villandry even impressed DH and it has a fab free leaflet, and Amboise had a brilliant free booklet for children (only 9 euros for adults there, I think) which DH enjoyed enormously
The Pagoda was 8 euros per adult. Given that at the moment, that's basically £7, that's quite a lot for some crappy wooden toys with instructions you can't read (unless you speak French) and a wobbly tower. We dragged the visit out to an hour and a half.
The Zoo at Beauval is fab. We were lucky to go on a very quiet day.
Few other child friendly attractions in the area. We didn't do the mine chateau park, or the aquarium, near Amboise. Again, partly due to money (everything seemed very expensive) and they didn't seem to warrant the cost.
We spent a week there and felt that unless we were prepared to spend a lot of money, we'd pretty much exhausted the area in that week.