Yeah, absolutely destroy my characters. I love the writing and the play that comes from difficult situations, poor outcomes, and otherwise “bad things” that affect a PC. Especially when it creates further story and RP opportunities in the aftermath. Of course there are limits, but these are also situations and lines that are already a hard ‘no’ in any game I’m going to play - and, as has also been mentioned a few times in this thread - trust is an important factor.
I’m generally very much of the opinion that failure is more thematically interesting than success. I love a failed roll, I love a failed mission, I love the drama. That has been where I’ve found my best success as a player and learned the most about the character.