Monaco is a fun example where stealth frequently fails and yet, you just have to scramble to do something and ruuuun. You can end up hiding and trying again but short of getting everyone killed, it's hard to get a game over. Your friends can revive you, as long as they don't get caught and killed themselves.

It's a good mechanic where it's more "let's go save Dave" then "thanks Dave now we need to restart".

No I don't know any Dave's, names have been changed to protect the guilty.