The original two Max Payne games are lovely and a favorite of mine to replay every few years or so, personally. They are very straight forward shooters though and can be a little hard at times, but extremely fun.
If you enjoy Sam’s writing, you’d very much enjoy Max Payne 1+2. Experience where it started, as it were.
If it was going to be anything like how the Artemis Fowl movie ended up being, y’all dodged a huge bullet. I’m still sad about AF.