One point - the author's a nice guy. I don't agree with his modding views, but he's a nice guy so I'll give him that credit right off the bat.
As far as his mod goes - I don't like it, and that's generally because of his modding views. He's trying to do everything, and it tends to force everything to be incompatible. I would say it's much better to have a more focused view, develop it, make it great - and then tag it along with other mods that do different things. And in fact, many things he's done have already been done, but are now compiled into his single mod (not saying he copied it - but he's implemented things already implemented by others).
By doing everything - yes, it works smoothly together. But by doing everything, it limits the scope - it's now incompatible with the many other fantastic additions to Skyrim (some which go way deeper in terms of content, but are more focused), and it's also limited by the fact that he's
one guy. Imo, a mod like say, OOO, should not be done - Oblivion (imo) needed that overhaul to that stage, but Skyrim does not - so a different approach should be taken.
My two cents. Again, this is nothing against him - he's a nice guy. So don't give him flak. But that doesn't mean our modding ideas agree, either.

On the flip side, it does make it easier for some users. They can grab one mod and not have to deal with juggling a load order, using Wrye Bash, BOSS, or anything. Just install, see the change.
I can see where you are coming from being a moder Pluto. But I need something like this to use mods. I don't like altering the game balance via smaller mods - I have this mindset that makes me feel like I'm cheating if I use smaller mods, even if they actually make the game harder it still doesn't feel right.
I know it's a singleplayer game, but for me playing any game especially RPG is about: (well other then actually playing a character in a fantasy world) theorycrafting, coming up with different idea's and trying to beat the game as it was designed by the devs. I could never become a game developer, at least I would never be able to play my own games.
With a mod like this (I would actually like it to do more), it's more in line with mods like, lets say: Urban Terror for Quake3, E.Y.E for HL2? Dayz for Arma II, CS for HL and even Dear Esther for HL2 - well you get the point - mod's that basicly creates a new game. That way I feel like I have to adjust to another game, instead of feeling that I'm adjusting the game to me, when using smaller mods.
It feel's like I create my own game when picking mods all over the place - I don't like that. I'ts really hard to explain this wierd mindset I have, hopefully you get it.
Making up your own rules by allowing to carry the ball in soccer would just feel silly and break the game but playing Rugby/American Football would be fine.