The way this superweapon will work is going to ensure that it is not easily abused.
First, you have to actually fly the ship to the sector you want to "zap". Unlike with vanilla superweapons, this automatically creates a risk factor for your shiny toy.
Second, the weapon will have a relatively long charge-up time before it detonates. In this time window, the defending forces can attempt to knock out the Titan - not an easy task, but possible with a massive focus of fire.
If they fail, their sector will be completely wiped out. The gravity shockwave will destroy everything, from smallest frigates to capitals. Of course, the defenders can choose to retreat before the weapon fires (I will attempt to have a direct visual cue as to how close the Titan is to generating a black hole), to save their fleet.
Unless the Xin have brought some Suryata cruisers along, which will require destroying first since they can keep a fleet from phase jumping.
Combine that with the new toys the vanilla races will get, like mines, interdictor cruisers and improved static defenses, and you will have an interesting set of tactical moves and counter-moves which I hope will spice up the gameplay some, especially in multiplayer.
Also to note is, although the Last Stand will include new planet types made by Uzii (and probably a few by myself), they will be adjusted for balance. For example, I don't like the bonuses the Military planet gives. Coupled with the massive tactical slot count, minefields and improved defenses the mod will bring, they would be somewhat unassailable and no one wants that. The Xin specifically, being a turtler race, would be able to fortify such a world to a degree which would make it virtually impossible to crack.
And the disabler weapon you speak of sounds interesting... perhaps the Remnant or the Hegemony will have some use for it. The Xin like to simply smash through he enemy and then drop those nasty bioforming spores on their planets (aside from the World Devourer the Xin have no dedicated high-yield bomber) and consume them slowly.
And... no problem about the long post. I seem to like long posts. As is evident.