A story based single player campaign with the raw tension that FS2 I can't think of any off the top of my head. A similar one would be ME2 and ME3 but those fi

A story based single player campaign with the raw tension that FS2 I can't think of any off the top of my head. A similar one would be ME2 and ME3 but those final missions had the same structure as any other mission. Once you kill off the enemies your fine, no sense of tension. Nowadays if you're looking for that sort of tension it's more likely built into gameplay mechanics like dark souls. But any tension you feel there is incidental rather then guided by a fixed single player campaign... and once you master the mechanics the tension inevitably lessens.