Is drupal hook system is really fruitful for production sites?

Drupal has hook system. But after a certail level it raise performance issues. Running a lot of query on calling hooks, specially node_load and user_load. Although life of developer become much easy by this concept but at the same time when looks at query log, certain question rises.