Dhruin
SasqWatch
ModDB is holding their annual Mod of the Year contest. Surprisingly (to me), Oblivion is the only RPG with a mod nominated for the contest, with neither NWN or NWN2 to be seen. Anyway, you might want to check out Oblivion's Nehrim: At Fate's Edge in the Upcoming category and the huge collection of other (mostly FPS and RTS) games.
More information.
More information.