Just a quick note, Microsoft has released Visual Studio 2012 and Team Foundation Server Update 1. I'd been using the CTP ever since October and it adds a number of really nice features. Especially the improved support for testing SharePoint applications and other improvements to the Test Runner are what I was looking for, but there are a number of other improvements as well!
For the full details on what's new in TFS, check out Brian Harry's blog. And the new features in Visual Studio 2012 are detailed here.
Important remark: a new version of the Team Foundation Server Power tools is coming soon and the previous version contains features that may no longer work with TFS 2012 Update 1.