For style, I'd have to say the original in TSFS. But for purely gorgeous visuals and emotional gut-punch, I'm going against the grain here and going with the E-D in Generations. For me, the D was the ship I had watched the most since TNG came out when I was in middle school, so I was sad to see her go. Plus, the whole evacuation sequence with the children really showed the impact of what was happening, and then showing the crew having to ride the saucer down and not being able to do a thing about it was very tense.
(Difficult to put this into effective words. I'm an engineer, not a writer!)
(Difficult to put this into effective words. I'm an engineer, not a writer!)