I actually thought the Colossus died in a really stupid way, and that's why people love to hate it. The ship itself, while looking like an oversized water pistol, was relatively effective as a warship. It consistantly smashed up a bunch of destroyers and lesser vessels while taking only trivial damage, and it stood up decently well to a Sathanas. Now the weapons package could be slightly improved (like bringing some of her guns up to par with a Sath's BFReds) but the ship itself was pretty effective. And it would have survived if command hadn't ordered it on a suicide mission and scuttled her drives (no other explanation for the "DISABLED" tag in that mission) and it could have been used to cover convoy retreats and gotten out of system like other valuable fleet assets before the Capella star went boom. Instead, it just sat there and took a beating from a Sath and hardly even fired back.