For those interested in the UI changes in 2007 specifically with the impact on custom solutions and add-ins you need to check this out:

Developer Overview of the User Interface for the 2007 Microsoft Office System

</steve>