Here's a look at some of my favorite games. I must say pretty much anything from PS is my favorite. Ragnarok, Helldivers, Spider-Man, Ratchet and Clank, etc.
What I love: Primarily story-driven, third-person, high-fidelity, single-player games with solid fighting characteristics with simple upgrade paths. FPS are cool too. Anything with "power fantasy".
What I hate: Anything complicated that I have to scower the internet just to learn how to play. Anything with classes or numerical attributes (Strength, Vitality, etc). I know this comprises many popular games, and if you like it, I'm happy for you, it's just not for me.
Edit: no corporate trash. No Ubisoft, EA, Rockstar, Denuvo, or remote accounts.
An old but gold would be any Max Payne game. I only played the first one but boy, was it awesome. I think it ticks many of what you mentioned:
The only thing you may not like is the graphics.
Max Payne II holds on really well. I don't know about 3