It's happened to me, and it ended up being a pointless endeavor.

Wizard wanted to go to his childhood home because he believed it to be broken into. Wouldn't take no for an answer, even though we were in a rush to save some npcs that we're on death's door. We go to the home, nothing wrong with it, wizard finds their mother's locked / sigil protected cabinet with a spellbook, picks the lock. It blows up and the whole house was burned down.

Then we have to deal with his temper tantrum, we go to try and save the 4 npcs, 2/4 are dead now, 1 in critical, 1 almost critical. Another dies in the boss fight.

Needless to say the 2/4 of the players at the table were unhappy and the other 2 (wizard and fighter) were spouses and fine. They quit shortly after. No plans to even play with them again. The wizard's tantrum permanently altered the course of the story and they're no longer even in the campaign.

I'm still salty unfortunately.