You're stuck in the future where the bad guys win that will happen if you don't find a way to get back. The entire environment is your reminder, not some gamey timer-till-failure, and the epitome of 'show, don't tell' for what happens to the world and the people living in it if you fail in your quest.
Not really. At no time during the entire mage mission did I feel one iota of concern that I might actually fail to achieve anything. It was a forgone conclusion that I would return to the past and deal with Alexius and steamroll the entire thing, just like every other so-called 'tense moment'. The Mage quest is a linear slog through a poor attempt at shock visuals. Oh no, my companions are all red and sparkly and say they're going to die! Oh no, Leliana is all tortured and prematurely old looking. Shocking (yawn) revelations that I know the moment they are revealed will have exactly zero lasting effect. There are no secondary objectives, hidden or orherwise, and no chance of anything you do in that future actually mattering, because it isn't going to exist when you're done.
At least the Templar side actually allows you the potential to fail at secondary objectives, with consequences, and does so twice. You actually have to make decisions and work effectively, or you will absolutely lose an advisor and some of the better war table missions. Important NPCs can die on the Templar side, changing available future actions in the game. What does the Mage side offer that is even remotely comparable?