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.
Surprised no one mentioned the Batman Arkham games or Tomb Raider reboot trilogy (2013-2018). Both are third person action games with simple, but enjoyable upgrade elements.
Arkham Asylum may feel a bit dated, but Arkham City and Knight should still feel pretty fresh. And I think the Tomb Raider games hold up well.
I also suspect you've played them, but the Uncharted series is also great.
Other mentions that fit the third person, decent-good story, and fast/fun action:
Jumping on here to give a second recommendation for Hi-Fi Rush. Game was so good i had to quit before finishing. Finally came back to it to see the ending and it was just as amazing as I thought. Very emotionally satisfying game.