At no point during the game did the wild hunt ever appear to be as much of a joke as Cory and his troops towards the climax of DA:I.
I'm going to call it, at least for me. Personally, Corypheus was the most underused main villains for a BioWare in any game I've ever played.
Also, after 16 years of BioWare games only missing two (KotoR and Jade Empire,) Corypheus was the lamest, most anti-climatic final boss fight in BioWare's history. I don't count Mass Effect 3, due to not having a boss fight at all outside of two marauders and a husk.
NWN: Three mind controlled adult good aligned dragons. This was after the dracolich from a few hours earlier.
NWN: HotU: Saved the city (and maybe the Realms) from a powerful Demon Lord.
ME1: The Saren fight was at least made interesting by the dialogue. The fight itself wasn't anything special, but the atmosphere was great.
ME2: I liked the Baby Reaper fight personally. At least I was fighting a giant killer robot while taking out all sorts of crap at the same time.
ME3: No final boss, but taking out a freaking Reaper on foot did help make it for it.
DA:O: One on one duel with Loghain, then the Archdemon and all of his friends.
DA:A: Possibly the Architect and definitely the Mother.
DA2: Meredith was an extremely fun and frankly, badass fight. For the rushed time, they did good on that front imho.
DA2: MotA: A wyvern, a bunch of guard mooks, while dodging fire rings
DA2: Legacy: Corypheus. If you are at least a little bit of a fan of DA2 and haven't played the DLC, I recommend it. It does explain a lot about Corypheus and how he was released, but I also thought it was a great DLC and of itself. Tip: Take Anders along for a pre-boss warm up.
DA:I: Doctor Corypheus Evil, shooting freaking laser beams out of his hands. After showing up on occasion in the game to "Mwhahaha" in some memorable but sparse sequences. Halfheartedly summoning a few mooks that even without white masterwork Tier 3 takes literally seconds to kill. His dragon provided something of a challenge, but it was over all too briefly. Between that and the plot flag bug I tripped the first time, that's been since patched (did too much damage too quick = cutscenes didn't kick in = I had to restart the fight,) it took some of the wind out of my sails.