We took our two grown sons and their families (11 in total) to Provence for 2 weeks in June 2008. The trip was so successful, we are returning in mid-June 2010 for another 2 weeks. Included in the first trip were two 5 year olds and a 2 year old (will be 7 and 4 for the upcoming trip). We trained from CDG airport to Avignon and rented 3 cars there. This allowed for flexibility of schedules and separate excursions if wanted.
We would ONLY stay in Gites and only with those having full ammenities (pool, table games, exploration areas, etc.) in order to keep all entertained. Plenty of Roman ruins in Provence to visit which keep the younger ones entertained.
Gites are a better bargain as they allow for your own pace for cooking or eating out, staying put or exploring, and for cooling off in a pool if in the summer months. Try to find a Gite with the owner(s) or managers on-site. They are a great source of information on local restaurants, off the beaten track places to visit, grocery shopping, emergency dentist, etc.
Definitely take the smaller children! Our then almost 3 year old granddaughter is the impetus for this coming return visit. SHE starting saving change upon our return to the States for the return visit SHE determined we were to have! In return, they will give you a perspective you would not have had as a perhaps somewhat jaded or time worn adult. It also shows them the need for an American to learn another language. They will see the need imediately, and will pick up the local language VERY quickly!
Enjoy!
Brooks and Priscilla