The series still exists and will exist for a very long time. Your memories still exist, but I can't speak to how long they will last. The movie version can never actually ruin the book, or the game, or the events of real life upon which it is based.
I don't expect Max Payne 3 to be good, or bad, because I have no prior experience with this studio of Rockstar's. They made Bully, according to what I've read. Was that any good? (The concept seemed fun.)
*Still waiting for A.Wake...*