Call of Duty: United Fronts combines the vanilla game with the expansion and includes a ton of new missions. It’s a must play modification.
Die Hard: Nakatomi Plaza is terrible and the Improved Edition is a mod that changes some things for the better.
Payne Evolution is a mod for Max Payne 2 that attempts to replicate the gameplay of Max Payne 3 and includes a significant amount of additional content.