I for one plan to make use of MagicWillNZ's Dark Republic mod (partly because I also plan to have a hand in its construction).... as well as the inevitable Steampunk mod(s?) and Dragonlance mod.

I'd try the inevitable Star Trek and Star Wars mods.

What is Rapture?

George Martin's style Game of Thrones or LOTR. 

Some space TBS mod (possibly original one and not just Star Trek/Star Wars/Galactic Civilizations/Master of Orion... mod).

More interested in a Legend of the Five Rings (or anything japanese/chinese [fantasy] based, I suppose) mod though.

Or a land based mod that mixes science and magic, allowing me to play with [arcane/techno] mechas and [arcane/techno] wizards. Not holding my breath while waiting for this though.

I'd like to see a mod with an ancient/mythical Greek mood to it.

With all those mods, I'd not need more (TBS) games for a long while.

I know I'm making a Warcraft Mod

That better not be made off WoW once i get sc2 i shall delete my characters.

Temple of Apshai...

Dread Lords Invasion!

Spaceships land on the planet and war begins (like Avatar)

I would kill for a dune 1 (the video game) mod.

  I want to add a mod that would have bunch of hero characters from different fantasy lore.  I would have Merlin, Sir Galahad, Gandalf, Aragorn, Elric, Corum, Fahfrd and the Grey Mouser, the Drizzit, Conan, Ged, Rand al'Thor and a host of other heros and anti-heros

  For cities, villages, towns-Camelot, Gondor, Greyhawk, Tristram, Baldur's Gate, Homlet, Rivendell, etc.

  For Factions-Arthurian, Tolkien, Melnibonean, Cimmorrean, the Forsaken, etc.

  For Cults, Gods and Demi-Gods-Glorantha Death Cult(troll), The Cult from the Temple of the Frog, Elemental Evil Cult, Thor, Poseidon, Lolth, Moridin, Cthulu, Isis, etc.

  Nexus of Worlds   In the cosmos there is a place where Worlds and heros collide..

Discworld, all the way.

I would love campaign based on famous DnD Settings, such as Forgotten Realms and Dragonlance