Oh I know exactly where you're coming from, and it's not a stupid fear (to me at least). It seems to be quite common; some of us are just a little more sensitive of those fears or think about it more?

It's my own personal thing to stare at the things that scare me. I fucking hate being scared of the dark

Story Time: I was a toddler and my parents took me to a fireworks show. I had an absolute meltdown as they tried to get me out of the car, because the explosions scared the shit out of me. They pretended they would leave me in the car, and I didn't give a fuck, I was scared and would happily stay there. So they pulled me out and carried me into the bleachers so we could watch (it's supposed to be fun)

So I sat at the show, and I had my hands clamped against my ears, trying to escape the noise. My dad pried my hands off of my ears as fireworks were exploding.... and I absolutely loved how loud and bright it was. The scary booms became delightful, and I loved it. It still sticks with me, how much I was about to miss because it was scary to me (and loud)

Though it does sound like my dad was being a dick (cause it was assholish)... I'm glad he got me to take a look that night, through hell or high water. It's helped me to sit with a lot of "loud noises" throughout my life