I'd recommend checking out any game developed by Paradox. You haven't seen fantastic mods until you've seen what people can do with Paradox games

For that matter, some games that Paradox only publishes (e.g. Cities: Skylines) also have fantastic modding support, though that's hit-and-miss compared to the games they develop in house.