Let me say this, though,
I've recently purchased Wolfenstein New Order & Colossus.
I've been BLOWN AWAY by the writing and narration of New Order that it has me fully invested to finish the campaign just so I can experience Colossus.
Also, Shadow of War has been so fun just to play, even without doing shyt regarding the story. The Fortresses, the pit fights, the nemesis system all create organic narratives and experiences that feel similar to what I love about multiplayer.
I would also suggest single player lovers start really focusing on smaller scale indie games - they give you that gripping story & gameplay in a much more manageable package that is fulfilling.
Suggestions:
Inside
Limbo
Little Nightmares
This War of Mine