I find Drupal modules addicting - they can add an amazing amount of functionality to a site. The problem is that I (and my clients) often get addicted to adding more and more modules once they get the hang of what their Drupal site can do and it's hard to stop. The real cost is the performance it puts on your site.
Performance & Scalability
