The actual finale of the story was kind of underwhelming, though the hooks for future games are down right amazing! Do not read this if you haven't finished the game
Flemmeth is housing the spirit of Mythal, the supposed Evlen Goddess that created the World, and her goal is some kind of Heaven Shaking Vengance, and currently she has the Old God that was sealed in Morrigans child.

And Solas was the dude who gave The Elder One that orb in the first place, as well as being the Dread Wolf!

I love that puts so much more context to him and Coles conversations, and where he confirms that the Elven Gods were not actually gods. I can't wait for a new game/DLC.