I've always seen "Near TPK" is the best possible result in a game.
The players get all of the the exhilaration of a life or death struggle but then….they do indeed make it.
As for the original OP--
I like the idea that a player can be clever and target the ogre's dex or the wizard's strength, so I see the idea that they party's wizard needs to be clever enough to play around his or her own crappy str save as simply the flip side of that.
Tho if you have players who aren't thinking that way about the game and never will and never want to, that's not a mechanic that'll appeal to you.