Classic corridor shooters fill this niche pretty well for me, if that kind of on-rails experience is what you’re looking for. I recently played F.E.A.R. and it’s first expansion Extraction Point (don’t play any later expansions or games in the franchise though) and they’re some of the best, tightest and most satisfying FPSes out there. Metro 2033 is also good for this.

If you want a no-nonsense RPG I want to put in a good word for Skald: Against the Black Priory which is very tight and linear with minimal fluff, focused on telling its story and doing a few things well rather than spreading too thin.