Mafia: Definitive Edition has one of the more substantial mod scenes for a linear single-player game, largely because the Script Hook opened the game up. Free Ride Deluxe is the headline act — it turns the free roam mode into something approaching a full sandbox.
Ranked by hand, not auto-generated. Every mod links to its full page with install guide + compatibility.