The Defiant (original) completely and utterly destroyed after getting the shit kicked out of it thoroughly for several minutes. That has to win really, all the others made it out partly intact or repaired.
Ah, re-reading that you want ones that survived. I'm not sure really, Voyager has chunks taken out of her and managed to survive it. The Enterprise D saucer still could have been beamed into orbit and reused to some capacity.