You're right - a better example would have been the opening battle of First Contact.
QFT. And when they did try to show a bit of the battle in the DS9 premier, it felt really small and not scary. In fact, since the had the Borg just grab and hold the Saratoga
for minutes instead of just blasting it the way they did the Excelsior class ship, it sucked the life out of the scene.
Gotta say that for some reason, the destruction of the Odyssey was extremely impactful on me. I don't know if it's the angle they used or the perspective of the ship being docked that gave a feeling of enormous size to the ship compared to the space station or what, but when that thing blew up, my jaw dropped.
Back on topic, good to see you back Jack and I hope you will keep beating the drums for stories. Get your hands on a good story and you will find a way to make it work!