Title*
The answer is: There is no best aura.
Otherwise we would have just one.
PvP: Devo against heavy hitters. Retro against fast attackers. Resist Auras against Mages, Locks and Priests. Conc when you need to heal yourself. You'll be changing aura ALL the time. If you picked Sanc aura then you'll most often use this to dish out more damage.
Arena: Well, this IS PvP... See above.
Raid: Depends in which group you are put. Resist Auras may sometimes help but the resist does not stack with anything else so their use is limited. Retro does not do enough damage. Only good on a Pally tank for threat I suppose. Devo is the "default" aura. Conc would be somewhat good in a caster group, although they just shouldn't be hit. Otherwise Sanc again for simple DPS increase.