About L.A. Noire

Although the game has some action segments (shooting, chasing, etc.), these are optional. The game will offer to skip them if you fail them a few times. Most of the game focuses on performing police investigator-like duties, finding evidence, examining evidence, interrogating witnesses and suspects, etc.

This is also probably one of the few games that fit both action and adventure genres but isn't action-adventure.