Well I've heard that a lot of people go crazy mod hunting, and forget to enjoy the actual game. i just don't want that to happen with my game. In the console its all about the game itself, and not just looking for whats broken and needs fixing.
Not all mods are about "fixing". Most of them add content that the modder thought would be fun in the game. As for mod hunting, you don't need to go crazy with it if you don't want to. I usually only look for cool mods once a month, just to see if there's anything "cool" that would make a cool addition.
As for which system, my advice is to look at the advantages of each system, and decide which advantages you like better.