I know what you mean. To make my Inquisitor seem at least a little bit smarter than the average dolt, I always have to get (at least) the arcane knowledge perk.
It's presented to be a perk that increased our knowledge of the arcane and relates subjects, but it always astounds me how it adds to her common sense and obvious deduction skills.
Agreed, I try to get those as soon as I can, but I'll still end up missing some opportunities to use them by the time I get enough Inquisition influence.
Eh, I suppose no RPG will ever make people happy in that regard. I either hear people complaining that the protag is not smart enough OR they're Mary Sues and they know everything and everything comes easy for them. I obviously can think of things I'd do differently with either my HoF or Inky, especially in hindsight, but overall I'm not unhappy.
Some have made me happy. Fallout 3's use of Intelligence and certain perks giving you much different dialogue options was pretty sweet, since I could actually understand NPCs and not be a bumbling fool. A shame FO4 scrapped that, but that's another topic.
Anyway, it's not just about the protagonist being smart (coming up with creative solutions in battle or good strategies in cutscenes sort of thing), it's also about knowledge - too many times, knowledge they really should have. There are plenty of examples in Bioware games, but the one that immediately springs to my mind is Shepard in ME3 not understanding engineer Adams' explanation of the upgrade to Normandy's stealth tech. Shepard, you're an N7 operative and captain of a ship. You would know exactly what Adams' is saying
That stuff is going to be basic knowledge for any soldier in the Alliance Navy, better yet a captain and special forces operator. A simple fix is just to have the protagonist do the explanation instead of the NPC.
And if being smart/knowledgeable means they get accused of being Mary Sues, so be it.
And as for DA2 - I'm not so sure the writers just... got bored and forgot about it. I think the bigger reason the Mage/Templar war was dropped like a hot potato is because BioWare scrambled to distance themselves from DA2 in pretty much every way. People didn't want a human protagonist, so they took an extra year to let you pick different races. People didn't like the small, repetitious maps, so they made a bunch of huge and unique areas to travel. People didn't like the DA2 companions, so they were all quickly swept under the rug or stuffed into multiplayer cameos with Varric (The only character that was widely well-received) being the only character that actually had a major role. I mean, originally Hawke was supposed to be the Inquisitor, but they ended up dropping the plotline because everyone hated Hawke - so now there's just this awkward plot thread where Cassandra spends all of DA2 looking for Hawke and making implications about the character's future only for it to end up going nowhere. And if I recall correctly, the Mage/Templar war was supposed to be resolved in an expansion for DA2 that ended up being abandoned because of the game's poor reception.
I agree that much of DA:I's design was an over-correction for DA2's criticism, completely in line with Bioware style, but I don't think the bolded is accurate. Their original plan didn't have multiple races (or at least not dwarves and qunari) and they only added those once they got an extension. So in that case it wasn't a knee-jerk reaction to DA2, because if it was they would have included it from the start.
Similarly, Isabela is the only DA2 companion in multiplayer, and she was added months after release, most likely as an incentive for people to try the MP/stick with it, since it was failing. Again, it wasn't planned from the start. Although the lack of DA2 companion cameos could still be a knee-jerk reaction, I don't know.
The Ghost state is when he is transcendent without a body and his soul is seeking an host it is the state that can be seen when the red lyrium is killed where a part of Corypheus after a certain amount of time travel from A:The red lyrium To B:Corypheus.
Show me, because I have no memory of this either being shown or explained.
Actually the choice to bring with him his dragon was dramatically stupid and it's served that contrived finale.
Corypheus knew that the dragon was his only weak point and he knew that the Inquisitor gained the well of sorrow which was knowledge that could have been used against him.
In short he knew everything and could have predicted everything.
Corypheus doesn't necessarily know that his body-hopping abilities would be disrupted if the dragon was killed. As Midnight Tea pointed out, he's been using powers he doesn't fully understand the entire game.
"In short he knew everything and could have predicted everything"

There's simply no consistency - nothing to bring back old fans, because the story, characters, and game play changes every time. I'm not going to blame that on the writers quite - well, I'll maybe blame them for tacking their little story experiment onto an established franchise rather than just making it it's own thing (Where it probably would've been better received anyway.) but I'd like to think that the general discontinuity of Dragon Age is just them over-correcting in response to criticism. But they've got to stop, and they've got to find some commonality. That "Thedas is the main character" line is just blatantly untrue when they pull so many retcons and oscillate so much on the tone - they need something more. Mass Effect had Shepard and the Reapers and some major recurring characters. Dragon Age has nothing. There's nothing to bring back old fans and make them stay. Each game's a crap shoot, and basically has to be a success on an individual level, as well as put up with the stigma of upsetting old fans who were wanting and expecting more of the same.
I agree with the bolded part 200%.
That, and I think that Cory might have thought that Inquisitor is way too unprepared for anything he was about to throw at them - the re-opened Breach, the separation from remains of Inky's army, leaving them with only a few companions at hand, the whole temple flying and on collision course with the hole in the Veil, etc. It may even be that he wanted to sacrifice his dragon to buy him more time, while he'd expend the last of his energy to forcing himself through the Veil and reaching the Black City that way. After all, in his mind, it was the 'battle for godhood' and he things that the way of obtaining one is making yet another trip to the Black City.
Huh, I never thought that the floating temple was on a collision course with the new Breach 