Haven's fall and the theme song being sung gave me chills. It was very well done.
In the main non-DLC game, Corypheus as a villain was not great because he gets stymied by the main character at every point. He never really has a confrontation where he cleverly overcomes the Inquisitor. It's more like he had a massive lead that the Inquisitor repeatedly reduces.
But it's only when Trespasser comes out that you realize Corypheus' relative ineffectiveness is intentional.
The events of Trespasser really takes the cake. All those little hints with Solas and the Elven pantheon and all the Elven artifacts, they were perfect. You'd look back and think, "Wow I should have seen that!" The whole storyline was quite beautifully crafted and well planned out.