I've noticed that with the group I play with the best moments tend to be when something goes horrible wrong. Case in point our last session our team was ghosting this museum to steal and old book for Arcane inclined people. Everything was going smooth and by the numbers until our decker crit botched a stealth check. All hell soon broke loose and we made a beautiful mess of things to say the least, however we did get the book and barely made it out with most of our skin intact.
Ok now that the rant is over my point (without getting into all the crazy details of the run) is that the run got really crazy but also really fun because of the mishap. And in reflection of all the missions I've done, It’s the big mess ups that end up being the wild fun rides that make SR worth playing, IMO.