The pirate event is horrible, as are many mega events. The mega events are a good idea in theory, but they were poorly implemented and highly exaggerated, making most of them game ending.
Scaling would have a been a really good idea, Stardock...
I disagree - the mega-pirates are the only event I would categorize this way (well, and the "subspace tear" that limits speed to 5).
The Peacekeepers can be similiar but tend be erratic; they may not work as intended (only attacking ships out of influence borders) but they frequently focus on some races while ignoring others and never seem to totally destroy every ship in the galaxy, the way the pirates do. The Jagged Knife are actually more opportunity then obnoxious, when viewed the right way. The Dread Lords are either a fun challenge or a freebee planet. Most of the others aren't that "mega".
The AI will never recover from this, so its almost an automatic win when you recover.
And this is the big problem with the pirates. The point of the mega events was to be unbalancing, but the problem with the mega-pirates is that it's always unbalancing in favor of the player, because the AIs simply can't deal with it. Again the Peacekeepers are similiar but have a smaller effect, and their occasional mysterious habit of totally ignoring a race can swing the game in favor of that AI.