I understand the logic train behind this thing but no, I've never wanted anything terrible to happen to me, regardless of potentially badass results.
While 'man burns down drug den after spouse murdered' might be an awesome headline and one I'd certainly read, I'd hate to be the dude who has to live with himself afterward. A lot of superheroes who fixate on that kind of thing are well documented when it comes to the kind of mental trauma they experience either pursuing or achieving their goal.
I suppose yes, I do want something to happen to me to provoke a radical change in my life, but I suppose that is common fantasy... have my book picked up and become a bestseller, win the lottery or whatever, but to have something important to me stripped away to achieve that end... I don't know, I'd take mediocrity any time.
And considering I've explained some of the things I've gone through in my life and had all kinds of "Oh my god how did you even survive that?" or "I don't know how you could cope with that stuff" pretty often repeated, and I still feel this way, I think it's a pretty solid sign that most tragedy doesn't bring uplift. I imagine more people are broken than empowered this way.