Many of those mods only alter Daggerfall's graphics; if memory serves, there were three or four packs that added quests, and nothing more than that. I do not recall if those quests were made by users or by someone at Bethesda though. Either way, it certainly doesn't compare with Morrowind's mod support and editor (just to name that one). That, and Daggerfall's mods could not (or did not, as you will) alter the basics of the game, like creating more "dungeon parts" for those random dungeons, adding equipment, or radically altering monsters (though Andyfall did have a specific human monster).
Lords of Magic was a fantasy TBS game published in 1997 or so by Sierra, so the official site may have been shut down since then. The Underdogs have some information available on the game, including the Expansion Set that was released a while later.
The Babylon Freespace conversion is available
here ; it does not actually require you to have Freespace 2, but the download is rather heavy.