This has been a very long debate and this is like the 100th thread on the matter and I don't see the point in arguing anymore, specially when the lore is not very clear.
The only things clear things are the following:
1. The old circle system is forever gone in Dragon Age lore and it won't make a return.
2. The Templars have lost a lot of power and respect. The scale of which depends on who is divine.
3. Most importantly the life of mages improves in all of the endings, again the scale of which depends on who is divine.
Now some elaboration.
1: The old circle system are completely gone if Leliana becomes divine or if you side with mages and Cassandra is divine. If you side with Templars and Cassandra becomes divine she will create a reformed circle, which you can ask her for details, Its nothing like old circles and mages have a lot of freedom and autonomy in it. In Vivienne's case she makes mages control the circle, and provides more freedom than older system. The important part of this system is the fact that mages and mages alone have a say in fate of the circle, Templars are simple glorified watchdogs heavily controlled by Vivienne herself.
2: Templars completely disband for good if Leliana is divine and Cullen was persuaded to stop taking Lyrium. If Cassandra becomes divine and you side with mages they still end up making the college after events of Trespasser which is Templar-free system. In case of siding with Templars and Cassandra becoming divine, this is the only ending in the game that Templars have some leniency, but still its nothing remotely close to power and respect they demanded before DA:I. In case if Vivienne she almost ridicules Templars by completely making them irrelevant in controlling the circle and only keeping them around with leash as glorified watchdogs. Templars actually rebel if you sided with Templars and make Vivienne divine, otherwise if you side with mages they accept this fate.
3: As explained above all if the endings result a better life for mages, whether inside college or circle. At the very least they have a lot more freedoms, dignity and autonomy inside circles, and completely control their own fate and future in college. Its always a win for mages in Inquisition, no matter what you do.
Obviously the people of Thedas, or at the very least majority of them have no problem with these situations. Of course people here are allowed to express their opinions but the main topic of the thread is the flaw between mage vs templar plot, which even the game itself favors the mages, for reasons I personally agree with. The game slowly builds itself to announce how the old circle system was based on corruption and deception starting from its core aka Seekers and the Chantry's ignorance regarding it. Then confirms this to you when even the Chantry apologists admit to it. You can even make Vivienne admit Templars were part of the problem and contributed a lot to mage rebellion. She accepts Templar cruelty but disagrees with rebellion as an answer to it.
Edit: At this point no one knows how much of the endings will be respected, but for now these are conclusions of the Dragon age lore so they need to be addressed.