One of the significant issues we've seen with MS Project + SharePoint synchronization is matching MS Project resources with SharePoint members. A resource may be spelled one way in MS Project but exists as a member in SharePoint completely differently. As a result, connecting the two was a point of emphasis for the new IntelliGantt Add In for MS Project 2010.
In this video we try to show how simple it is now:
The key takeway is we've brought the task of aligning resources and members front and center now right on the ribbon. In fact, we feel this is a great example of a complicated action you can accomplished right on the ribbon that required a dialog box back in the days of menus.
Now, given any shared project, just select the MS Project resource in the bottom dropdown and the corresponding SharePoint member in the top dropdown and click 'Connect'.
Some would say it's actually intuitive now.