does it focus down on individual queries as the cause of high resource usage, show query plans, suggest possible improvements?

You say servers must be defined by physical name which is obviously an issue with clusters, but the SSC servers being monitored are clustered? Is this a case then of monitoring all the nodes in the cluster but having to know which node is currently active?