I've been waiting long time for this. Visual Studio finally got official support for distributed source control. I personally find it a bit annoying that they opted for Git instead of Mercurial (which is my favorite) but I still like this move. Distributed source control in any flavor is brilliant.
This will not be available out of box until Visual Studio 2012 update 2. However, there is nothing stopping you from manually installing a preview version.
Based on this I think that we can be fairly certain that days of ugly (or non-existent) Windows interfaces for Git are numbered.
PS: I will stick with Mercurial for now - it has great standalone interface and fairly decent plugin for Visual Studio. But I do see myself in future converting few Mercurial repositories to Git just for fun. :)