While it's true that Arkane's superb FPS immersive sim Prey is probably the closest we ever got to a Half-Life 3 in terms of gameplay mechanics, there's no doubt in my mind that, in terms of narrative storytelling and game structure, Metro Exodus is the closest we ever got.
There hasn't been a better narrative single-player FPS than Metro Exodus. This cinematic FPS drips with quality and, as it's clear that developer 4A Games was hugely influenced by Valve's most famous creation when making it...