Story in Max Payne games has that exact portion of noir. Addictive indeed and simply great. Mainly in the first game.
I loved the rag-doll physics in the second game but the story kinda lost that feeling it had in the first installment. Nevertheless, it still was a wonderful game.