Hmmm, if he is outdoorsy and noise sensitive I would look for ‘Wild ‘ style campsites where you can be a long way from other tents, often in a little glade on your own, and have a camp fire.
Have some good luxuries: proper coffee, have a good cool box do that you have properly cold beer / wine, cook fabulous food over your fire ( get him into this) with a stove as back up.
So, the opposite of EHU. Personally I hate sites with EHU because the tents are too close together for my liking and someone always uses it for a TV which you can hear..
See what he is comfy sleeping on: lost of people really like the inflatable Decathlon camp beds with a SIM on top (you don’t need to spend that much on the kids mats).
Coleman and Outdoor Revolution do blackout bedroom inners if it is the light in the morning that keeps him up, and the new silicone mouldable ear plugs are quite good.
For me, my SIM, proper coffee, cold beer, good food and a campfire make Camping my favourite experience.