[Strategia_In_Ultima]

Most Original Mods:
-Adamant Mod (continual work-in-progress, current version 0.15 (or o.16xx dev), but it'll work); adds Magic and Organic races, Energy and Machine races are in the works, completely redone propulsion and weapons.
-Space Food Empires; still in early beta, but it will work IIRC. Command an empire of foodstuffs bent on boiling every other type of food. No bread.

Good Add-Ons:
-TDM-Modpack; makes the AI a helluva lot better.
-Cultures & Demeanors Mod: My only finished project, adds around 30 cultures, doubles the amount of demeanors, adds a happiness type and has several other small changes.

Largest Changes:
-Eclipse Mod; massive overhaul of stock game. Viewed by most people as a great mod IIRC.
-Dark Nova Mod (DN4); adds a slew of ship and unit sizes. Good for people who like to play with large fleets with mixed hull sizes.

Sci-Fi Mods:
-Atrocities' Star Trek Mod (AST). I don't know what the other ST mod is exactly.
-Babylon 5 Mod; notorious for two things, which are A.) having the longest thread currently in existence on the forums (over 5000 posts) and B.) never having produced a well-playable version in all its years of development.
-Star Wars Mod; MIA. Intimidator's working on one, but nobody's heard from him in quite a while.
-Red Dwarf Mod; Eeeh?
(note: the Red Dwarf Mod doesn't exist)

And all the other mods mentioned here, of course.