Are there any compilations of mods that involve potentially Midas magicka, new combat skills, graphics overhaul, changed leveling and stats system, and possibly new quests/areas to explore? I have no idea if simply adding on all the mods that contain said things would ever work...so I was just curious if someone has taken the liberty to merge them all together.

Unfortunately, yes. Some people through the years have done pretty much that. It's not looked upon too kindly by the modding community in general though, for a number of reasons.

edit: Though, on a more pleasant note, you can certainly use staggering amounts of varying types of mods together without so much as a crash or stutter. I should know.

interestingly appropriate use of the phrase 'taken the liberty'

"Mod Compilations" always seems to be a touchy subject around here, so I am just going to close this now. I have well over 100 mods running smoothly on Oblivion, including some big ones, and the use of Wrye Bash and OBMM and BOSS and other things had made it all work together very well.