I'm mainly interested in statistics for:
Can SiteMetrics provide this and if so does it require Extension:SocialProfile?
See the screenshot for what stats SiteMetrics provides by default. It sounds like hacking it to provide support for such stats wouldn't be too difficult, I think, but I might be mistaken.
As for it requiring SocialProfile, the short answer is yes. The long answer is a bit more complicated. You can see a subsection called "User and Social Statistics" in the screenshot. If SocialProfile isn't installed and you try to see "Friendships" or "Foeships" statistics, for example, you will get an error about a missing database table (user_relationship in this case, as the underlying code will try to perform an SQL query against that table, but it can't do so when the table doesn't exist).
It should be relatively easy to change the code of the special page so that the dependency on SocialProfile can be removed. However, it isn't a high-priority task for me. If you want it done, I suggest filing a bug ticket on our Bugzilla.
