it all depends. Example, if you want to assign a role to a new user when he signs up you can install http://drupal.org/project/autoassignrole module which does about 10 more things or just write one hook_user function.
If you install a module for every piece of functionality soon you'll end up with a huge codebase and the hell the author is describing.