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:
- 3rd Person
- Story- driven (it has a great narration and comic book style to tell the story between chapters)
- solid gun fight with the famous bullet time. There is no upgrade, just new guns
- Not complicated, go forward and shoot things
- No attributea at all.
The only thing you may not like is the graphics.















That is just too on the nose, didn’t they know that Frankie Boyle quote?