Surely it's better just to leave them at home so you can enjoy a bit of peace and quiet?
I chose to have a child because I wanted to spend time with my child, not leave them with someone else for a week at a time.
I chose to have a child - why should someone else be given the task to look after my child, unpaid? My parents have done their stint bringing up me and my siblings.
For us, holiday time is precious - DH has limited time off particularly. During the working weeks we are busy - out of the house early, home latish, even when DD was small. Why do I want to spend those 30 days away from the child I chose to have.
Besides - NONE of those things have happened to us when we've taken DD on holiday abroad - at any age, from 16 months to now at 17y.
She's always loved going on a plane, and stays to her seat. She has always been quiet entertained with things we take with us, or by us (or if they are travelling with us, family). She's never been allowed to run around on a plane, and she's never been a screamer or one to tantrum much - and never did on a plane or whilst away. She used headphones as soon as she was able to sit and watch things - first time was probably on the 9 hour flight to Florida, aged just over 2.
On holiday she has always loved it - all that one to one (or 2:1) attention with new things to see and do. We chose not to use childcare , and spent our time together as a family, or with other family or friends. She has always liked warm, or even hot, weather.
We;;ve always done a variety of holiday times, but always ensured there is something for everyone and particularly DD, esp as she is an only one.
Holidays have never been a time of angst for us.