What I would like to see, but may require some time to develop, is a dynamic hull damage and debris system. When you take direct hull damage, instead of an image overlaying your ship, you'd seen scorch marks and hull breaches develop where the weapons themselves hit. These will disappear gradually as your health is restored. Hull damage visuals can also work in conjunction with ship injuries on higher difficulties, and will disappear after repairing them. As your HP drops to critical levels, you'll start seeing bits and pieces of your ship fly off. Then finally, when your ship explodes, not only will there be a random type of explosion, but large pieces of debris from your ship will shoot off in random directions. Anyone hit by these will take shield or hull damage in addition to damage caused by the ship exploding.
As long as STO adopts that model, I think it ought to be possible to apply damage textures to each of those selective parts. For example, we could get to see an Intrepid-class' right warp nacelle switch to the 10% texture/damage effect by itself.
To me, there are two ship destruction animations done mostly correctly, the Bird of Prey and the Intrepid variants.
Both of them have movable portions that separate and fly off as the ship is destroyed.
I would like to see the concept applied to ships that separate, like the Galaxy variants and the Prometheus variants, seeing the saucer section detach as the docking clamps fail and the saucer surge forward from the initial explosions shock-wave only to be obliterated as the Warp Core breaches.. That would be cool.
Canon explosions, like the splitting of the Defiant from the second battle of Chin'Toka, would be awesome, and haven't we seen just about every canon ship destroyed at some point or another?
I know we've seen the Oberth destroyed several times, and the Miranda, the Nova got a nifty little destruction sequence on Voyager. I'm pretty sure if we go through all the footage from the various Borg engagements and the Dominion War we can come up with the various ways the Nebula, Excelsior, and Ambassador classes (when added) blow up. (The Dominion War would also help illustrate KDF ship explosions too!)
Take inspiration from those to craft some booms for the non-canon ships, and we'd have some very visually appealing death sequences!