Just completed this as a 791 Arms Warrior without dying once; took about 30 minutes in total. Here are my notes from it, may they help others:
The quest started with an awkward pause after Odyn said he'd be sending us to Ulduar to help, quest objective stuck on "Listen to Thorim's response" with no action. Simply waiting around next to Odyn and Hymdall for a few minutes eventually completed it, allowing you to talk to [npc=96679] to port to Ulduar.
[spell=29838] is required. No ifs, ands or buts about it. I had Double Time while completing the scenario, but in retrospect [spell=46968] would've been entirely superior.
You will want to abuse the ever-living-life out of both [spell=29838] and Victory Rush.
- [champion=709] and [champion=708] will be with you. [champion=709] is the important one, as she brings a heal [spell=205327] that seems to consistently proc when you drop below 40% health. I was not able to discern if it would proc again without you going back above 40% health.
- The helpful NPCs in this scenario don't hold threat. Use them as a distraction, especially letting [champion=714] run ahead and aggro mobs for you. Just know that the slightest breath from you will pull aggro to yourself and then you'll have that mob until it dies.
- Addendum: Dvalen's body-pulling is unreliable. Stay well back from him as he runs ahead so you can see which mobs are actually going to get pulled by him. This well help you avoid pulling too many mobs and dying from it.
- You'll find the first demon boss, [npc=109800], after Kologarn's bridge fighting with [champion=714]: He hits like a truck but moves very slow. There are no enemies on the stairs. Use his slow movement and slow abilities as a chance to run away (use [spell=6544]!) and let [spell=29838] heal you up. Do damage in between. Rinse and repeat and eventually he'll die.
- To open Hodir's door, click the piles of chains lying in the snow. It isn't immediately apparent with the NPCs standing on top.
- The feldogs ([npc=109703]) on Hodir's stage with [npc=109801] will spawn throughout the fight, as [npc=109801] summons them with a non-interruptable cast, [spell=223115]. This is fine, as they are your source of Victory Rush procs. Try to avoid having too many attacking you at once as they have a nasty DoT ([spell=171444]).
- This is the first stage where I absolutely had to use [spell=118038] to survive.
- Remember to alternate your damage between the dogs and the boss, otherwise you'll be here forever.
- One of the trash pulls between Hodir's room and the icy hallway was the closest I ever got to dying, about 1-2% health, even with [spell=118038] and [spell=97462], until Finna healed me. Be careful here.
- You'll get to a portal room where Hodir and Thorim will chit-chat. Hodir mentioned that the demon's just keep coming. This is true: After the imps in the room are dead, don't bother killing anything else. Just head left and through the small doorway to the start the gauntlet.
- Packs of [npc=110413] will drop from the ceiling in in this gauntlet. They aren't too bad. Just remember to progress forward as each pack spawns and drops. I believe they spawn based on triggers, so if you move back and then run forward after killing a pack, it just spawns the same pack again (didn't confirm this though, its just my suspicion).
- The room with the eggs will spawn another boss, [npc=110349] who you will kill along with more spiders. This is the second closest I got to dying, but again Finna's heals and Victory Rush saved the day.
- Interrupt [spell=220267] here.
- Next (and last) is [npc=110620], who you find fighting Thorim at the balcony. Treat her rather like the boss at Kologarn's bridge by running away / using Heroic Leap to let Second Wind heal you up.
- Do not interrupt her [spell=210535] - Use it to gain distance from her and just avoid it's damage to proc Second Wind.
- Do interrupt her [spell=131577], for obvious reasons.
- At ~30% health, [npc=110620] will run away and jump off the balcony to escape. Follow her to the balcony to see what happens, and then you're done! You can then talk to Thorim to return to Skyhold and complete the quest.
All told, this scenario needs some work. I actually found it engaging, but only because I read this Wowhead page first and so went into knowing and expecting terribleness. Hopefully your attempt goes better!