BookBarbarian
Expert Long Rester
For me, it depends. I play a lot of Adventure League. If my character got killed in the first combat and the group didn't have a reasonable way to get them revived...there is very little incentive to stay. It's a module, not part of an ongoing story line that involves my character. Most of the people at the table are acquaintances, not close friends. And I probably already know how the module ends anyway, because you tend to replay a lot of the same modules with different characters.
If it was a home game with a group of friends, I'd be much more likely to stay. It's also much more likely that the DM would find a way for me to remain involved in the game on some level. But even then, it's possible that I would decide to head home or something if I felt that sitting around and kvetching would be more disruptive than helpful.
Good point about adventurer's league. I only play with friends, so the thought didn't even occur to me.