One of the really useful features of MOSS 2007 is the out-of-box usage reporting. However, it's not enabled by default. If you think you'll want to let site collection admins view information about top pages, top users, etc, then make sure you enable it centrally.
In Shared Services, under Office SharePoint Usage Reporting, click Usage Reporting. Then check the Enable advanced usage analysis processing checkbox.