Going to have to go with the iconic Executor class, but specifically the Lusankya I loved what happened to this SSD during the second battle of Borleias. Wedge and company knew they had little chance against the Yuuzhan Vong fleet that was incoming, so they decided to build a large metal spike filled with explosive within the superstructure of the Lusankya. Then they would drive this ill fated SSD into the incoming Yuuzhan Vong worldship, firing all batteries along the way. Wedge would pilot the SSD, and then escape before impact in an x-wing sitting in a Lusankya hanger bay.
I saw it as a beautiful death to an SSD that was in so many books I've read, the real end of an era. I was almost sad, but it was right for the Lusankya, being a ship of terror throughout its whole life, and then dying to save others.