I want to get back into Oblivion before Skyrim comes out, just to refresh myself a bit.
But I definitely dont want to play it stock again....let the mods begin!

Now, I dont really feel like DLing all these mods....Id rather just download the best all in one mods.
What are they?

If it's a compilation pack your looking for, then there are none.

I know two of this kind.

T.I.E and R.O.M. Both on TesNexus.

Abbreviations stand for.
http://www.tesnexus.com/downloads/file.php?id=35265
http://www.tesnexus.com/downloads/file.php?id=33114

Uh, not quite, but close. TIE and ROM are what's considered overhauls, they change a lot, but it's mostly gameplay related. TIE actually only uses vanilla content, no textures/meshes, but it still feels complete. ROM is actually build on top of another overhaul, OOO, or oscuro's oblivion overhaul. Franceso's is another, and combines with MMM (mart's monster mod) and ooo to create fcom. The main goal of these "overhauls" are to fix the whole world levels up with you thing, but often add other things as well, you'll have to check the readme.

You'll still want the unoffical patches. Probably a UI mod likes Darn's. Plenty of graphics mods for textures/models/meshes, qarl's is the biggest, but not necessarily the best. All natural is the most popular weather mod. There are plenty of good quest mods, you'll just have to search for what you want. Some like a magic overhaul like LAME or supreme magicka, you can even use both at the same time. Toggleable quantity prompt is a must for me, as is keychain. I'm currently using wrye leveling, though oblivion xp is good as well.

There is no all in one download pack for all of these. It'd be too difficult to cater to everyone's individual needs and tastes, and get permission from all the authors.

Modding is a rewarding experience, but you do have to put some time into figuring out what you want first, otherwise search the nexus and you can find most things. Phoenix created a topic here: that might help you : http://www.gamesas.com/index.php?/topic/1072579-the-any-mods-list-of-topics/

If you can respond with the kind of mods you want more specifically we can give more specific recommendations.

Someone really needs to compile some of the most horribly made and offensive mods into one pack so that someone can come into topics like this and say: "Oh yeah there's this totally awesome super sixy cool mod pack here that is the bestest!"
Saw a recent topic for "must have mods?" where someone said the 'tentacle mod' was his must have.... hopefully jokingly.


GENERIC:
If you want the most help possible it helps to give as much information, and uniqueness as possible.

Here's my generic written thing for these topics. if you want something specific give more details. I ask some questions in the below text as a small guide line. You can answer them if you wish:

OWC-ND is an overhaul and encompasses a lot of little mods like OOO does and comes with alot of content in a single overhaul.

I would recommend it: http://www.gamesas.com/index.php?/topic/1232576-complete-modded-oblivion-installation-guide/