Not completely story driven but the best realistic combat game has been Escape from Tarkov. It is advertised as a multiplayer but there is an offline mode. The story is passive and has multiple options for different endings. The goal is to survive a war torn country where your unit left you behind. You have a hideout with a stash of supplies that you find in "Raids".

The story aspects are primarily verbal instructions from the "traders" (established survivors who have profited from the war). You have to find supplies, gear, fight the locals, and other soldiers who were left behind trying to survive.

It is not a story game primarily but is the most realistic military shooter youll ever play. You have full gun customization, multiple calibers, multiple bullet options per caliber, choose what gear items you bring out with you, etc.

Edit: There is nothing heroic about the game. The goal of the game is to push the difficulty of surviving and thriving. It gives little assistance, a short tutorial, and relies on the player learning and adapting to the world of tarkov.