I know this is a long way off, but getting you a copy of Star Trek Generations would be worth it, if only to see the Death Star take down the Enterprise D. The saucer section then crashes on Endor, taking out untold numbers of Ewoks.
https://www.youtube.com/watch?v=jcDiZPJ0V0ESurely I already suggested making my “Fire at Commander Will” line, right? Then cut to a beam hitting the drive section and it exploding. Don’t necessarily need the saucer crash…
If the two ideas combine, then the stupid scene in Insurrection where the joystick pops up for Riker to fly the Enterprise should be inserted, to place more blame on him for crashing…