Hi, I have experience of this! You did mention a tourer as opposed to a static, and what I have found is that setting up & holidaying with 2 DC is very manageable, I'm fine at towing, connecting Calor gas, sorting out the loo, but personally I am pretty naff at reversing my folding caravan onto the pitch. This requires spatial awareness and object rotation ability, which I really lack.
Other caravanners are friendly, but not to the extent of volunteering to manoeuvere my tourer for me! I strongly disagree that someone will always wave you in / help you. People have been smiley & nice to me but not offered practical help, not even on Caravan Club Sites. (They usually just watch me do it all by myself!)
The Caravan Club runs courses so you can get lessons, some driving instructors can also teach this. BUT I would strongly advise you not to purchase until you are confident at manoeuvering. Think - if you arrive on site and you can't do it & no one is willing to help you'd be really stuck.
You say you have CFS but are doing OK at the moment, how strong are you? Are you strong enough to hitch / unhitch? Are your DC old enough to help with this?
You also have to consider the kerbweight of your car and whether it will be able to tow. I have a folding caravan which weighs 750kg, so my Volkswagen Golf can easily tow it. Also, at that weight, if I've reversed it not quite into the middle of the pitch my 2 DS and I can wheel it into position.
Owning a static caravan can make for an amazingly easy holiday with the kids. Similar price to a tourer, no setting up to do, no need to book, just arrive whenever you like, unpack and enjoy!
Also regarding a tourer, if you want to set up an awning on your own, there are 2 things to watch out for. One is the weight of the poles & canvas - you can buy lightweight awnings if you shop around. For me the limiting factor is arm reach, you need to be at least 5' 8'' to reach high enough to erect the awning.
Other options if you've set your heart on touring is a campervan, Volkswagen or Adria for example. They can sleep up to 3 people, easy to reverse onto a pitch, they can be dear but you could buy second-hand, classic campervans are definitely in atm!
I really love my folding caravan, the feeling of freedom & we've had some great holidays. There are lots of things to think about though. I'd recommend joining the Caravan Club, it's really worth it, and non-members can visit their webpage & check the section on 'thinking of buying a tourer' for more advice.
Hope this helps and good luck whatever you choose x