These are what we call the 'YMMV items.' Things that some people find in this work. We call them 'your mileage might vary' because not everyone sees these things in the same way. This starts discussions in the trope lists, a thing we don't want. Please use the discussion page if you'd like to discuss any of these items.
Fridge Brilliance - Earth has very good diplomacy skill against the AI, but that doesn't help them against a human, right? Well depending on the player, when playing as a different alien race, they might see the Terran Alliance and decide "eh, they're cool" and put less espionage, etc into their faction.
Strictly speaking it doesn't help them much against a human — the greater your diplomatic bonus over an AI race, the more willing they are to bend to your whims. Since this is dependent on the difference between your and the AI's diplomatic bonus, Earth tends to be less susceptible to it.
Game Breaker - Psionic Beams. Some of the Neutral alignment bonuses are pretty overpowered too, especially the instant terraformer and research centers.
The racial bonus "Creativity" is possibly the worst offender, at the start of every turn there is a 5%-10% chance of automatically completing the current tech research regardless of time left, with the exception of the technology victory tech which it does not apply to, its prerequisites have this chance but down somewhere at 1%-3%. Considering that even on fast research settings with a tech focused race major techs can take 40+ turns to research this is boon. Additionally if the current research would be completed on the turn anyway creativity gives you the next tech free, including the final step for a Technology Victory... Praise unto the Random Number God!!!
The Thalan Empire was generally regarded to be the most overpowered of the playable races in the sequel's first expansion Dark Avatar because factories only cost a fourth to build for them relative to other races. The Arcean Empire's ability to always strike first makes them this to anyone who relies on glass cannons, as they'll blow their ships' weak defenses to hell before the glass cannon can return fire and also makes glass cannons very, very powerful for the Arceans since if they have enough firepower to kill the enemy ships in one attack they won't need any defenses.
That One Boss - Play a map where the Dreadlords have a substantial presence and watch as your early game colony ships, defensive (or offensive if you play that way) fleets, constructors, scouts, and freighters get brutally destroyed by flying chunks of daemonically posessed space coral. Actually wiping them out will be a long, painful, and economically ruinous process considering that their fleets will be entirely composed of what are essentially evil precursor ships. On the plus side, pretty much every other major and minor race you share your galaxy with will hate them and also fight them.
Dreadlord ships are also glass cannons; they do more damage in one shot than any player ship can survive, but go down a lot easier than you would think. Using glass cannons yourself lets you basically Zerg Rush them.