I recently upgraded my Community Server 2007 site to CS 2007 SP2. The only difference I've noticed so far is that recent comments aren't showing up in the What's New section of the homepage. It turns out they purposely stopped that from happening after so many requests to remove comments...