Imma be posting some screenies later(and I'll download those mods too, I guess)
I guess you're aiming for a really good view in Oblivion, so these screenies might interest you.
The mod I have to have such effects is Natural Environments(the whole pack) only.
They could've been better if I had more mods, but my laptop can't handle it too much.
Extra: This place is from a sidequest, that's why the coloring and textures are different. It's a really beautiful place, you should look for it. Sad thing is that it's only full of trees.
And here's some dungeon screenies,