It sounds pretty reasonable to be able to do this in 10.6 reporting. You could create 3 dynamic data sets with the query builder, just like you have outlined already. Create 3 custom tables (might be able to do it in 1) with summarization to get the totals.
We do something similar for our BGPv4 peers with 10.3 (and it still seems to work after out 10.5 upgrade this week)
Some of the peers are exteral/unpolled nodes so we can add custom properties to them (like the contact information for the remote NOC)