We use SMS to support about 1600 users over 20 sites and we use the inventory functions, program updates and remote control functions and it would be worth it for those alone, especially since some of our sites are an 7-hour drive from the main office.
However, some of the additional value recently has been the ability to quickly check for the presence of specific programs and files. Like most other large agencies, we got hit pretty hard by the ILOVEYOU virus and SMS was very useful in identifying the machines that would have to be re-imaged (in addition to checking for current virus updates). A more recent use has been to identify the presence of software (e.g. Napster) that causes both legal and technical concern for the organization.
We also use it for budgeting and forecasting because we can easily query for all machines that are only 32meg of RAM or those that have hard drives less than a certain size.
And we haven't used it this way, but another company I know that had problems with users