The hallmarks of a Rockstar production these days: good atmosphere, very disappointing story and player agency.
Like many Rockstar releases, this could have been a very, very good game - but just like Rockstar (and Team Bondi in this case) manages to consistently deliver very good atmospheres and high-quality settings; they consistently manage to find a way to limit player agency and impose their own sense of morals.
*Spoilers will follow*
Like in GTA IV and Red Dead Redemption before it, the protagonist of LA Noire spends most of the game doing other people's bidding and rising through the ranks, with little choice about anything. Like in GTA IV and Red Dead Redemption before it, he is haunted by a messed-up past; and like in GTA IV the protagonist ends up screwed without there being anything you as a player can do about it; and like in Red Dead Redemption, the story eventually makes him pay the ultimate price, effectively severing your ties to the protagonist, and gives you a faceless placeholder character to play instead.
For some reason Rockstar is making it their MO to have their games end this way, as if things like player agency just isn't something they like. Or as if there sense of what is right and wrong or fair or proper should override everything else.
On top of that, LA Noire suffers from the usual console-only hiccups - sluggish loading times, rigid mission (or case) system, and of course, a savegame system that is completely out of the player's hands. There is only one save file, and it updates automatically.
In short, if you are the kind of player who likes any kind of input or control over your game, or who likes to feel that what you do in the game world eventually results in something rather than just falling flat, LA Noire will leave you disappointed.