I also am extremely fond of the new reporting features! It is so easy to create custom dashboards and provide the information needed for various types of presentations.
Some of the other uses for SharePoint include:
Project site – for team collaboration (discussion list), document storage, etc.
Various lists which can be either specific to a project (on the project site) or a “global” list for all projects such as Risks and issues list, Action items list, Deliverables list, Customer/Project contacts, etc.
Depending upon your version of Project, you can link a SharePoint List with your project MPP file
Do a view that shows items on a list (or more than one list) belonging to the person viewing the site so they know what they are responsible for
Do a “dashboard” of all projects as I previously mentioned
SharePoint is a great tool for project collaboration, even if you are not using Project Server. It can serve as a “lightweight version” of Project Server by setting up project sites and using a common SharePoint list for project deliverables, another for risks and issues, etc. It can be especially helpful in cases where project information is located in different places. This can be handled by having a SharePoint list of projects which includes in each project record basic information such as the Project Manager, Project Lead, Customer, Start Date, Current Risk Level, etc. as well as links to specific information such the location of the contract/SOW, specific project site or documentation folder, schedule (like from a third party tool), and status slide. Then, a view can be made on a SharePoint site or page providing the information for all projects and can even be customized very easily using SharePoint Designer to show status by color coding.
I just tested this out in MSProject 2013 and it works great! Thanks, Sai!