If you finish Max Payne II on the hardest difficulty, Mona survives, this is the true ending of the game for those that go to the trouble to see it. So Mona is alive.
I don't think Max Payne II is a "love story" per se, but certainly romance is involved and Max ends up falling for her somewhere along the line as they battle against the forces of evil.