Okay. This is the list from that video:
1. Unofficial Oblivion Patch
2. Really AEVWD Cities, Imperial City, and New Sheoth
3. Natural Environments: Weather, Vegetation, Water, and Habitat
4. Oblivion Graphics Extender v2: Volumetric_SSAO.fx and Godrays.fx
5. DarNified UI
6. Qarl's Texture Pack v3
7. Color Map Mod (1.1)
1. The Unofficial patches are a must. Make sure to get all of the ones relevant to your game (the base one, Shivering Isle and for the DLCs)
These are something to include even if playing an essentially unmodded game, they don't add anything new, just correct errors.
2. RAEVWD is good. It can cause a framerate hit, but with a decent machine most of the options are well worth it.
3. Disagree with this one.
Weather: http://oblivion.nexusmods.com/mods/18305l is by far the superior weather mod. It requires Wrye Bash, which is a useful tool to use anyway.
Vegetation: Just makes trees bigger. If you want that I think the preferred is http://oblivion.nexusmods.com/mods/23783
Water: The front runner is definitely http://oblivion.nexusmods.com/mods/37825, and if you are using OBGE anyway why not.
Habitat: Adds non-interactive insects and birds overhead. The only one of the Natural Environments mod that I would recommend.
4. No real opinion. I would suggest playing without them first, then see what you like.
5. Check out http://oblivion.nexusmods.com/mods/11280: Mnor update of Darnified UI, but Mainly offers the change of colouring (there are other colour schemes to be found on the Nexus as well.)
6. Check out QTP3 Redimized Reduced: Offers optimized and reduced version of QTP, without much if any loss in quality.
7. There are a number of map options. Dynamic Map is well worth checking out.