I went through the upgrade to Office 2007 yesterday... while I'd followed its development through Microsoft blogs and preview articles, I hadn't ever installed any of the pre-RTM versions. The upgrade itself was pretty painless, though, I did have a bit of a scare at the last minute when I fetched it off MSDN.
On the MSDN Office Pro 2007 (English) page, Outlook isn't listed as one of the included applications. However, this page says that Office Pro includes Outlook 2007 with Business Contact Manager (not sure what BCM is, but I doubt I need it). There have been a few blog/newsgroup posts from folks who have downloaded it and didn't get the BCM option. Thankfully, I burned the ISO image to a disc and Outlook 2007 is included -- it just doesn't have BCM.
There are also a number of posts about a mix-up with product keys on MSDN. Apparently, the product keys for Visio and Project are the same, as are the keys for InfoPath and OneNote. While the key will work for multiple activations, once it's used for a certain application it can only be used for THAT application going forward. So if you use it to install Visio, you can't use it when you install Project. According to a Microsoft blog post, that should be fixed this week. I didn't need Project or InfoPath right away, but I did want OneNote and Visio... so I went for it.
From there, the upgrade was smooth. I removed Visio and OneNote in advance, but let the installer for Office 2007 upgrade my 2003 installation. This picked up all my Outlook account settings and data files and worked like a champ. The Office install asked me to reboot, though, the OneNote and Visio installers didn't need it.
Since then, I've found/discovered just a few things and made some mental notes:
In any case, the whole experience has been reasonably solid and very stable (aside from the one issue with the MindManager addin... which was easily fixed and isn't the fault of Office at all).
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way, shape, or form. Seriously.