I find most of them pretty useless and boring. Except for Unrelentless Force which I really like. But I do NOT want to go through my 3rd play though doing the 1st quest and some of the main quest just to get this again. No way!!!
Storm Call level 1 and 2 are almost not worth it when comparing their recast timer to effectiveness. I havn't gotten level 3 yet, but I'm hoping it will actually behave like it did in the Teaser trailers before release. Level 1 and 2 don't even hit the dragons.
Aura Whisper is awesome even at level 1 (I am not even unlocking level 2 because the first is so effective)
Unrelenting Force is obviously a winner. (except when Drauger spam the level 3 version; they don't have recast timers, because one of them hit me five times in a row within 30 seconds; that is obviously poor game design)
Become Ethereal is useful for jumping down cliffs and mountains. I did use it once to evade some powerful enemies by jumping off a cliff.
Whirlwind Sprint is very useful. I have made use of it for evasion and charging a ranged enemy.
What bothers me about Elemental Fury is that it doesn't work on Bound Swords. The bound swords are not enchanted, but the game still classifies them as such. I suppose they did that because certain perks for bound weapons can add enchantment-like effects.