I started playing TES 4 again because of these mods :
WaterfrontMarket - expands IC waterfront with new shops, stores, inns, taverns, etc
http://www.tesnexus.com/downloads/file.php?id=22834 (http://www.tesnexus.com/downloads/file.php?id=22834)
Elsweyr the Deserts of Anequina - this mod adds whole Elsweyr
http://www.tesnexus.com/downloads/file.php?id=25023 (http://www.tesnexus.com/downloads/file.php?id=25023)
http://www.tesnexus.com/downloads/file.php?id=25150 (http://www.tesnexus.com/downloads/file.php?id=25150) (colored map for Elsweyr) RECOMMENDED
Integration - The Stranded Light - includes more than 60 quests with a strong emphasis on thinking, character interaction, choices, consequences, and lore
http://www.tesnexus.com/downloads/file.php?id=22320 (http://www.tesnexus.com/downloads/file.php?id=22320)
Blood&Mud - A huge quest mod (3 major + sidequests) which completely changes the look of Bravil (includes over 800 voiced dialogs)
http://www.tesnexus.com/downloads/file.php?id=12016 (http://www.tesnexus.com/downloads/file.php?id=12016)
Lich Gear - Lich equipment becomes usable (enchanted and unenchanted versions)
http://www.tesnexus.com/downloads/file.php?id=16121 (http://www.tesnexus.com/downloads/file.php?id=16121)
Windfall - large quest and adventure mod which features a new island and ton of quests and sidequests (more than 33 hours of gameplay)
http://www.tesnexus.com/downloads/file.php?id=21989 (http://www.tesnexus.com/downloads/file.php?id=21989)
http://windfall.freeforums.org/index.php (http://windfall.freeforums.org/index.php) (this is the official forum - some quests are buggy so if you are stuck you can find help here)
SPARTAN VIs Diverse City Guards - this mod makes the guards in every city different
http://www.tesnexus.com/downloads/file.php?id=11211 (http://www.tesnexus.com/downloads/file.php?id=11211)
ENJOY PEOPLE !
Oh and here are some cool screenshots for you :
Spoiler: click to toggle
"The Guardian" by niaguag
(http://www.tesnexus.com/imageshare/images/1290474-1247236137.jpg)
"Archers Ready" by Rogue Sun
(http://www.tesnexus.com/imageshare/images/388026-1214734035.jpg)
"Cyrodiilic Drive-by" by Rogue Sun
(http://www.tesnexus.com/imageshare/images/388026-1192596814.jpg)
"Heroic Charge" by Rogue Sun
(http://www.tesnexus.com/imageshare/images/388026-1214332097.jpg)
"IC" by dyfed_99
(http://www.tesnexus.com/imageshare/images/381430-1207535525.jpg)
"The Sky above" by MRBee30
(http://www.tesnexus.com/imageshare/images/511948-1239398997.jpg)
"A more simple time" by arnoldvsthegooch
(http://www.tesnexus.com/imageshare/images/303243-1242967627.jpg)
"8 pm" by sonk2
(http://www.tesnexus.com/imageshare/images/726256-1239201614.jpg)
"Welcome To My Nightmare" by Carah
(http://www.tesnexus.com/imageshare/images/691792-1241448025.jpg)
"Jessica" by CapsAdmin
(http://www.tesnexus.com/imageshare/images/250842-1230575703.jpg)
"Undead Legion" by deathknowz
(http://www.tesnexus.com/imageshare/images/457645-1246868007.jpg)
"Lightning" by siffreo
(http://www.tesnexus.com/imageshare/images/1206888-1247150204.jpg)
"Surrounded" by Nihilious
Average adventurers like this man die almost every day in Tamriel, each with their own story. Makes you wonder what got this Breton into this kind of mess doesn't it?
(http://www.tesnexus.com/imageshare/images/1036952-1247196937.jpg)
If you like playing with female characters (I know i do ;) ) then this is the mod for you :
Lattamer V3 ---> http://www.tesnexus.com/downloads/file.php?id=21608 (http://www.tesnexus.com/downloads/file.php?id=21608)
-----------------------------------
And some nice armors :
-----------------------------------
HGEC Slave armor ---> http://www.tesnexus.com/downloads/file.php?id=20693 (http://www.tesnexus.com/downloads/file.php?id=20693)
Spoiler: click to toggle
(http://www.tesnexus.com/downloads/images/20693-1-1225483165.jpg)
Argent Armor ---> http://www.tesnexus.com/downloads/file.php?id=19529 (http://www.tesnexus.com/downloads/file.php?id=19529)
Spoiler: click to toggle
(http://www.tesnexus.com/downloads/images/19529-1-1244932556.jpg)
Corinthian Gladiator armor for HGEC ---> http://www.tesnexus.com/downloads/file.php?id=21874 (http://www.tesnexus.com/downloads/file.php?id=21874)
(I'm not posting the picture... This one contains nudity)
HGEC- Yet Another Armor Replacer Mod - Fur Armor ---> http://www.tesnexus.com/downloads/file.php?id=22949 (http://www.tesnexus.com/downloads/file.php?id=22949)
Spoiler: click to toggle
(http://www.tesnexus.com/downloads/images/22949-1-1238196331.jpg)
HGEC- Yet Another Armor Replacer Mod - Iron Armor ---> http://www.tesnexus.com/downloads/file.php?id=22809 (http://www.tesnexus.com/downloads/file.php?id=22809)
Spoiler: click to toggle
(http://www.tesnexus.com/downloads/images/22809-1-1238275710.jpg)
HGEC_UFF_RM Shaman Clothing ---> http://www.tesnexus.com/downloads/file.php?id=19777 (http://www.tesnexus.com/downloads/file.php?id=19777)
Spoiler: click to toggle
(http://www.tesnexus.com/downloads/images/19777-1-1221317699.jpg)
I have also found a site with graphical enhancements for Oblivion... Enjoy
The Oblivion Texture Overhaul (http://devnull.sweetdanger.net/obliviontextureoverhaul.html)
Qarl and Timeslips Depth of Field (http://www.tesnexus.com/downloads/file.php?id=8771) ---> this mod makes distant object blurry and makes the game very similar to Gothic III
EDIT :
Map marker renamer (http://www.tesnexus.com/downloads/file.php?id=26389) ---> very useful thingy which enables you to add tags to maps markers
tags like these:
(http://www.tesnexus.com/downloads/images/26389-2-1249927966.jpg)