As far as I understand it the main reason why this thing exists is so that console players can mod their games, too. Which I wholeheartedly agree with.
Theoretically, it was also added to allow people to create their own mods more easily, and I believe that mods installed through the official mod manager would not break as easily with every patch.