I've replayed all my favorites and am need of something new. But it seems that for a very long time now, there have been no great mods released. I'm talking about big mods that offer something new to do and see... mods such as...
Gates To Aesgaard 1 & 2
The Lost Spires
Heart Of The Dead
Willie Sea's Haunted House
... and the like.
Have you checked out http://www.tesnexus.com/downloads/file.php?id=25530? Not a romance, really an action-adventure with a highly unusual house and companion thrown in.
What about http://www.tesnexus.com/downloads/file.php?id=23153? And, of course, http://www.tesnexus.com/downloads/file.php?id=17743, and http://www.tesnexus.com/downloads/file.php?id=15200, two companions that use the Underdark a great deal?
I second the remarks above about http://www.tesnexus.com/downloads/file.php?id=31692. A lot is finished but it's ever-expanding, and has plenty of unique flavor to the architecture, weapons, armor, streets, and shops. Fans of the Telvanni in Morrowind will catch a few jokes, too.
All of the above are fairly new, and as you're very familiar with most of what's been around for a while, perhaps they'll help.
Granted, http://knol.google.com/k/toql-the-oblivion-quest-list# isn't currently being updated, but if you don't have it bookmarked yet, I suggest you do so. When maintained, it kept an excellent list of quest mods. Dev.akm's simply on leave from modding due to having scripted a new bairn, along with his wife. I gather they're checking out the code at the moment. You know how young programming couples can be, but he has said he will return.