I can add to this a little, I think. I remember well the first time I heard something go BOOM, I had heard banging and the like, old style engine-weight pile drivers and small arms fire from a distance. But dad took me out at about age 2, maybe 3, and showed me what a rifle was, that it was going to make a very loud bang, but that he was in control of it. I was impressed, as dad had control of something THAT LOUD, That much excitement, it kicked the adrenaline right to the top, that first scare, and yet I knew that 'dad had control', so while I was startled, I was not emotionally scared, but the body reacted with the adrenaline rush, and so it was not a scare, but and excitement.
That carried over into me watching fireworks displays and later shooting and hunting and dad taught my brother and I how to Properly Use explosives, the difference between a controlled blast just enough to roll a large rock or stump, or enough to blast it and move it a goodly distance, and then there was the specific type and way the charge is set one can smash a good sized boulder with less than explosives needed to launch it (shaped charges do well).
However, now, having been through the military in my 20's, working as a welder, fabricator and self-employed as sword and knife maker I got a might more leery of big bangs and booms that were all too close and not at all intended, so now I tend to jump and NOT enjoy the BOOM's so much, in fact I tend to react rather badly to em now since they are one of my PTSD triggers, but for anyone doing a study on such, there is a basic, if condensed, life-track story of how explosions have affected me over a period of time, I remember being 2 and 3 years old, and am now 53.
Used to absolutely love 4th of July and other celebrations with the bangs and BOOMS, but now I have to do the earplugs, headphones, quiet room and sedation to deal with such, and I cringe and have even gone flat to the ground hearing explosions or backfire from a car near me. Used to be exhilaration, now it is something I nearly dread, sadly enough.