A new Freespace, with multiplayer mode but also with the same epic and chilling storylines from the first two games.
I’ve never found a game that replicates the feeling of FS2 but that could be because I’m old now and most of my childhood joy is dead. Excellent game mechanics, short missions, gradually upgrading ships and weapons and the feeling of a vast universe to discover.
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.
I’ve never found a game that replicates the feeling of FS2 but that could be because I’m old now and most of my childhood joy is dead. Excellent game mechanics, short missions, gradually upgrading ships and weapons and the feeling of a vast universe to discover.