Blasphemy! I can only assume that you're one of those people who think Max Payne is strictly a particular art direction, a common misunderstanding of hong kong cinema and film noir. Max Payne 3 is definitely a Max Payne game, crafted by people who understand the character and the genres the previous games borrow elements from. It ticks all the boxes:
- The failed hero
- Corruption
- Gangsters
- Damsels in distress
- Fatalism
- Getting in way over your head
- The underbelly of the beast
- Pessimism
- Cynicism

Max Payne 2 wrapped up all story arcs and characters from Max Payne 1. There was nowhere else to go with that story. Max Payne 3 is a perfect "10 years later" kind of story that handles both the genre tropes and references to the previous with extreme love and care.

That said, you are right about Hitman: Absolution. Mechanically and visually it is an excellent Hitman game. The problem is that the level design and AI completely ruins the Hitman experience. It is like being given a beautiful sports car, but you are only allowed to drive it around a dull dirt track. The wasted potential, the obnoxious story and characters, the flat immature jokes, the level design that necessitates a poor man's Splinter Cell kind of stealth play.

Hitman has always been best and most loved when it allows you to succeed just by confidently impersonating someone you're not. Absolution completely failed to balance the social stealth aspect of the game, forcing the player to duck behind sofas and dodge around corners in plain sight to reset the AI suspicion meter. It looks completely insane and makes no real world sense. All aspects, even the mechanically sound parts, suffer irrecoverably because of this.