Warrior is "eh..so - so". You get first strike (When attacking, not defending) menaing all your ships shoot first, then whatevfer is left alive, shoots back. Just on the first turn.
Hive = cheap factories. So they buy faster and build faster. Hard numbers I dont got, but they are cheap.
Breeder - I think its a 8x multiplier to population growth (per planet) when you are at 100% approval.
Isolationist - Enemy vessels move at max of3 spaces per turn regardless of speed when they are in your realm of influence. And you can colonize barren planets.
Diplomat - makes your trades better for basically everything. You get better deals on everything. There arent really any hard numbers, but tech trading is easier, selling or buying ships and planets from AI's is easier, and you can talk with the AI more frequently, I think every 4 turns or so, as opposed to 12 turns. Basically it makes you smart enough, good enough, and dawgonnit, people like you.
Manupulator - You can get AI's to attack each other more easily, not real numbers to give.
Super Spy - start with counter espionage and 1 spy. Is what it is.
Super Organizer - AI's with similar ethical alignments will sometimes come to your aid when you are attacked.
Super Annilator - Spore ships. They rock. You "spore" a world, it turns toxic and becomes yours...with small colonists already there and infrastructure intact.
Super Dominator - you get little ships when you declare war on people, more ships depending on current size of your military, but not really all that great.
Super Ghey Iconian Ability - colonize aquatic and some other hostile environment, maybe radioactive? I dont really care to look at it to remember.
Super Trader - start with all the trade techs ( trade, advanced trade, master trade ) and I think either a bonus to trade or extra trade routes, I don't remember
I would play them ALL, to see which is "best" for you. My guess would be you like Hive, Breeder, or Diplomat the best.