I've created a CodePlex project for managing alerts in SharePoint 2007 called SPAlertManager.It's a limited scope layouts application for managing alerts for all of a user's sites in a single place, along with the ability to sign up for an alert for a site (it creates an alert for all lists in the site). Just a proof of concept sample, but might be useful to someone someday.