It’s mostly designed for one-shot play, but there is a system for continuing with the same characters from game to game. I don’t know if it would scratch the true “campaign play” itch though.

As for “no!!” moments, one way the game mitigates that is by having the whole group succeed and fail together, so you might suffer setbacks, but you’re still all in it together with your friends.