Not played it yet but LA Noire looks good. There is some action but the focus is detective work.
Charlie Brooker on LA Noire
“And then there’s LA Noire, the James Ellroy-inspired crime drama, which has caused a stir, and rightly so, with its firm focus on narrative and staggering new facial animation technology. I’m a massive dweeb who keeps up with the latest gaming developments, and even I was astounded at what they’ve pulled off here. You’re watching actors give genuine performances – within something that is still defiantly and unapologetically a video game. The lead character is played by Aaron Staton, AKA Ken Cosgrove from Mad Men – and is instantly recognisable, not just from his likeness, but also his facial mannerisms. Amusingly, plenty of his fellow Mad Men cast members also show up throughout the game (as well as faces familiar from shows such as Heroes and Fringe), reinforcing the overall feel of the game – which is like working your way through a hard-nosed HBO police procedural miniseries set in Los Angeles in the 1940s. If you’ve never played a game, or you think you hate them – but my description sounds vaguely appealing, give it a spin. Just watch someone else play it for a while if you like. I guarantee you’ll be surprised.”
http://www.guardian.co.uk/commentisfree/2011/may/23/gaming-makes-hollywood-look-embarrassing?INTCMP=SRCH