But Cullen informs us that, magical abilities aside, Templars are among the finest soldiers anywhere, and even Bull comments on how well the Templar training is helping move along the Inquisition Army. Cullen may be a little biased, I'll admit, but usually he bends over backward to be honest. I'm thinking that Templars--real Templars--not drugged red popcorn Templars, probably give any fighting force a run for its money--unless I am commanding the opposing force because I am a video game god, at least when I am the Inquisitor! Bwa-ha-ha! <exit tongue-in-cheek mode>
I don't see how the templars are ineffectual to be honest. As Cullen and Alistair both point out, there's a great deal of discipline, receiving an education and combat training involved with the process of becoming one. The only real negative is how lyrium affects the mind. My dwarven Inquisitor was just told by Cullen since he chose the templar spec he's going to lose his memories slowly but surely unless he gives up lyrium, and even then he would suffer as a result, probably for the rest of his life.
And besides, Meredith was able to overthrow the Viscount who was before Dumar with a garrison of templars after he tried kicking them out when the Chantry gave an order to Meredith's predecessor to get involved with Kirkwall's politics because he was making things harder for Orlais, despite the Knight-Commander refusing by saying that the templars concern was magic and not politics.
And Meredith was able to hold power in Kirkwall after Dumar's death because the templars were the largest, and strongest armed force in the city.
I know I wouldn't want to fight templars unless I had some highly trained soldiers backing me up, or mages who could keep their distance while I kept the templars attention.
Ser Barris and Cullen both made it hit home, probably for the very first time despite me knowing about it, the kind of sacrifice templars actually make when they join (and what my dwarven Inquisitor was told by Ser when he joined.)
I still think the job attracts more undesirables, especially considering the templar codex in DAO and DA2 made it clear that the religiously fervent were looked at before those with strong character as a way to keep them from questioning their orders, and that's one thing that really needs to be reformed.