There's Testament of Sherlock Holmes, which is a new release.
A slightly older game is Heavy Rain, which has adventure elements but also some action sequences.
Then there's L.A. Noire.
Those are from the current Top 100 at Amazon UK.
There must be more that I've missed.