I found this random short film of how the fireworks in London look from a Spectator view in 2017. Might be cool to add in to see how the vibe feels in different cities.
New Years Eve Fireworks - London 2017
I chose 2017 as I was there that year too, so can tell you myself it's a kind of accurate clip expect in rl there's a lot of screaming ofc.
Also a random fact in London they release flavoured mist when they do fireworks and so you can taste hints of like cherry, or apple or some random favour in your mouth. For a bit it tasted like pineapple, i hate pineapple... rude that they didn't personally come ask me first out of everyone there???
luckily the torture passed quickly but I would've jumped off London bridge if I had to taste it any longer.