I am waiting for the updated Darth Mod Napoleon. Darth mod is a great mod alone, so im hoping the updated version will live up to my expectations.
I've heard rumours that a mod exists for Fallout 3 that plays the Crab People theme whenever mirelurks attack. I really hope that's true.
I would personally pay somebody to make a Fallout 3 sound overhaul. Ideally, so it sounds similar to this:
I can't wait for the Sword of Damocles warlords 4.0, but I am waiting for a CK2 mod about a fantasy or medieval game i'm interested in, or lets you play theocracy, pagan immediately, or muslim