I only use, as DA has said Diplo, Hive and Breeder. Though if it is a ZYW i will use....ermmm, well the Korath SA, the one with spore...i cant think of its name right now, but i dont think that is what your looking for anyway.

The pros and cons though with 2 of the 3 mentioned above, is that hive and breeder and this all depends on game style and what vistory your going for, but hive and breeder are pretty much usless after the first 2 years of the game. Once you are set up and you planets are built up they are little use. Diplo, though not as powerful as the other two has more longevity to it but still becomes redundant towrd the end of the game.

That being said, they are still the best way to get ahead in the game, with any other SA you would still be a mile behind where you would end up using one of the three reccomended.

(damn no spell check anymore....  )

I think the Yor's Super Isolationist is one of the most powerful and gets even batter later in the game. Having all enemy ships limited to only 3 spaces per turn helps your planets remain safe. Add military star bases with the 2 minus speed modules and your enemies have a max speed of 1.   <<<  ONE (when their turn begins in your territory)

The ability to colonizs barren worlds is a little bonus, it has the potential to give you addition colonies before the AI's get them. AT least its one less tech to get.

I live hive as well, i found that it worked well for me all game long.  Diplo is good too since it helps keep me out of wars a bit longer.  I stink at keeping 100% approval so i stay away from Super Breeder.

Super spy and super annilalator are useless.

Super Organizer works well if you have enough other races with the same alignment as you, an you are prone to having war declared on you.

Super trader is ok only in that you get the techs right away, trade never plays enough of a role anyway.

Super Adapter can be good in that you can get a hold of more planets during the colony rush. Late game it does you no good; well except that you'll have more planets in the late game. The trouble is, that it will be some time before you can get the other tech to get full social and military production on those worlds. It depends on the map you get i guess.

Super Manipulator, is also pretty useless. Basicaly it just save you a few bucks whne getting otrhers to declare war. Hmmm, I don't know if the ability allows ytou to get them to delcare war when they normally wouldn't. (Like sometimes when another's race name doesn't ebven appear n the list for the AI to attack). ANyone know?

Not really sure about the Korath Super Ability.

Super Warrior can be good if you know how to take advantage of it. You do all the attacking and you really won't need any defences for you ships. You can have the ole' cargo hull with massive weapons and win battles.

The Terrans also get an influence bonus which can be powerful (and annoying).  (partly comes from their special building)

Spore ships are very powerful, you just need to transport population to the planet (which is alot of micromanagement).

Thalan's super hive is great, but they are very hard to invade with.  (Soldier bonuses are limited)

The Drengin ability can be useful early - logistics is helpful, as well as military resources.  (which are always helpful)

The Torian super breeder helps alot early.  The 100 percent 4x growth is on a per world basis - really helps new colonies.

@Motti:  Its too bad that Hive and Super Spy don't actually work like Brad stated there; Unlimited Range would relaly make a difference (there IS a bonus, its about 10% extra range) and Spy Invulnerability (Loup would LOVE this I'm sure, spies really COULD be offensive, since you wouldn't need to worry about others stacking them on you)

ya gotta love the Krynn really.  Best race to use, and IMO, the hardest race to compete against when they are on your bad side.

Oh and to answer the original question: generally, Super Breeder; though I'm currently using Super Warrior for my custom race.  To me, the only stipulation with Super Warrior is that you give yourself the Luck and Courage abilities

Super Diplomacy, but only because it's tied to the Terran Alliance and I have been playing them pretty much all the time since TA was released.  Sometimes it does feel a bit too super, especially if your Civ has a lot of income to fund buyouts.