I mostly lost interest in fireworks a long time ago, but if you want to do fireworks American style just think "November 5th + 20% pointless danger." E.g. As a kid we used to wrap "whistling pete" fireworks in electrical tape then smash them with a hammer before we set them off. They usually just explode, but sometimes they shoot off in a random direction first.
What I do these days if assume most stuff is closed so I stay home during the day, Then in the evening I might go to one of the parks doing "official" fireworks to people watch.
I'm trying to keep the actual "rooms" from becoming too formulaic, it's the episodic part that's got me a little worried. I want my players to control the story but they're being sent on away missions so I'm worried they feel like they're just checking boxes:
Of course, the missions they go on are not happening in a vacuum and affect other missions and the overall story and they choose the missions.