Trying to give something back to the Community...
You can now download ConfigMgr SP1 from:
Seems Microsoft has really got their act together on this one as not only was the Service Pack signed off a week earlier than what I was last told, the download itself appeared the same day (normally there's a couple of days lag whilst the download file is passed to the team that owns the Microsoft website, they need to add it yada yada yada). So well done Microsoft.
The following below gives a high level summary of what's new/ change in SP1 although you might want to checkout the "Configuration Manager SP1 and R2 Overview (Level 300)" Webcast for full details (this Webcast also covers the upcoming Release 2 (R2) of ConfigMgr as well):
Configuration Manager 2007 SP1 now offers full support for management with Windows Vista SP1 and Windows Server 2008, integrates customer feedback, feature Integration with Intel vPro Technology and enhances Asset Intelligent features.