I come from an area where a large number of people were employed in the shipping business, and I often think back to New Year's Eve when I was little, which was the only night of the year when fireworks was a thing. To me, the most magical fireworks were the S.O.S. flares/rockets that sailors had taken home from their ships, maybe with the excuse that they were about to expire. These were completely silent, except for a modest whoosh sound as the rocket went up.
After a long evening of big family fun centered around huge amounts of food - dinner, desserts, age-appropriate drinks, as well as our own fireworks, some of which regrettably did make loud explosions, although this was short-lived, we went back inside for more food and increasingly cringy "true stories", lap-slappingly funny "dad jokes" etc until finally the clock approached that magical hour.
At midnight the sky could have maybe 50 simultaneous parachute flares, slowly, slowly floating to the ground, usually red, but sometimes orange. I would usually watch this from inside with the ceiling lights turned off, trying to count them all to see how many simultaneous ones there were at the moment and whether the number had peaked, and if so at what number. This was obviously much past my usual bedtime, so I would go straight to bed afterwards.
(The day after - first day of the new year, yay - always felt incredibly anti-climatic. For some reason, the snow was always melting on this day, and the only activity for us kids would be to go searching for the remains of spent fireworks. On rare occasions we would find what appeared to be remains of the mystical S.O.S. flares.)
I got a little carried away with that story, but the point was that you can absolutely have a lot of good-old traditional fun without loud, noisy fireworks!