I think the widow always tends to fall apart in comparison to the other golems. When you look at the botnet, armored, or cursed golem and their ability to cut a swathe through reams of AI ships, it just doesn't stand up. Sure, it can grab a whole lot of ships (and then die to concentrated fire from them). But in the same time that it does that, those other golems could have killed all those same ships. (Again, caveat, I haven't actually played with a widow yet, I'm going off hearsay. My RNG likes to give me tons of botnet golems and little else)
This is why, when you add a new unit, you want to decide on it's role, decide on how it will function, then balance it.
This is why the siege starships has been revamped so many times. It really does not seem to have a role decided, or if it did, It became invalid over time, and had to be replaced with some other role, without thinking it out. Long range artillery worked until radar dampening was added, as well as until it was decided that destroying fortifications from across the planet was not wanted. Annihilating ship engines worked as well, but the Riot is more effective IIRC. I personally do not think the siege starship(That is what I call it, regardless of the new name(s)) fits in the game at this time, and aside from not knowing how the game would handle old saves with siege starships, I personally think it should be removed. (or re-imagined with it's own role)
Flagships work as fleet boosters.
Raid starships work extremely well at bypassing defenses and taking out targets of opportunity.
Bomber starships are good for heavily damaging large ships,
Riot starships are good for wreaking the engines of all enemy ships, as well as having a few other uses, such as tanking, or tractoring ships. (sounds an awful lot like a black widow golem to me, but also is much cheaper, is replaceable, and therefore is not quite as much of an issue when it vanishes in a puff of smoke, I think it may be more efficient too, when the widow ought to be, being a golem)
I really think many of the units need to be reexamined and determined what their role overlaps with, and redisigne one of them (if they are at different types, meaning fleet ship vs starship vs golem vs spire vs warhead vs turret etc)