While it would be ideal to gather the great minds of modding like Arwen, Mez, and XFO and have them work together to create one great overhaul, as stated, everyone has different tastes. Therefore, to counter possible tensions and provide better and more choices to the mod user, I say it's actually better to have them all work separately and do their own thing. That way, the mod creator has more freedom to make what they want, and the user has many choices to choose from instead of picking from one singular mod that could have some things they don't like. Everyone's happy.
And for those who really must have EVERYTHING OVERHAUL in their game, I'm sure once enough overhaul mods are made, we'll be getting an FCOM of FOIP type mod system that combines them all together in how the user chooses.
Yes this might all take awhile to blossom, but once it does, it will be so much worth the wait.