I know most of the Bethesda RPGs have massive mod support, and there’s games like Minecraft that have more mods than anyone can imagine. I would consider those games pretty playable in their vanilla states. Would you say there are any games that were “saved” by modding? Or that are still kept alive by thriving modding communities? What are some of your favorite mods?
Civ 4 had a great modded scene. The Colonization remake/spinoff in particular has a must-have mod in the way of The Authentic Colonization. The main game, though, had loads and loads of incredible mods. My personal favorite was the Ryse series of mods, which tried to more accurately model the rise and fall of civilizations via various mechanics. I have a lot of hours in the random map variant of it, Ryse Rand.
Modding as we know it today really started with Civ (Civ II, to be precise). There were several sites sharing different mods back then. I had one of the most popular ones for a while, to the point where MicroProse asked to post a link on the official site. The mods were ZIP files with instructions, and nobody had come up with a name for them. I started referring to them as “modpacks”, and that stuck. Eventually that was shortened to just “mods”. True story!
(FYI you can see here where MicroProse put links to other websites. Mine was listed in 1997, where the wayback machine doesn’t have entries.)