In Vivienne's epilogue, the mages will rise in status for the moment that she is Divine. The templars are still addicted to lyrium and used as a leash to keep them in line by vivienne who is the head of the chantry and controls the lyrium trade and the mages in the circles, i.e., her loyalists sycophants will bear the fruits of her favor for as long as Vivienne is in power. Personally, I think by not addressing the can't leave the order and using lyrium as a leash problem of the templars will breed resentment and mages who don't like Vivienne will join in on that. Which could be a festering problem. Afterwards, a muggle Divine will succeed her and the mages loses their leverage, a mage divine who had mage interests, even thought they were self serving.
Cassadra's reforms does seem to be: "be more nicer", half measures to appease everybody but elthina thought like that and Kirkwall still went to ****. Let's hope Cassandra knows what she's doing. From what I gather, she tells the college of magi/templars if were granted independence, they are free to run the circle with out chantry oversight but I guess she doesn't keep to her word because the college of enchanters start infighting with her circle of magi and templars who aren't leashed again as cassandra promises could risk abusing the circles again and cassandra won't stand for it. If conscripted then the inquisition mages push for reforms and starts a shadow war undermining her authority or the templars are given independent authority through their association with the inquisition and could turn the inquisition evil after the inquisitors death. If the templars become seekers then the templars of terinfal redoubt are charged with being the old guard over the new circle prisons and the templar jailers. These new seekers at least are taught to be ethical and learn from past mistakes by reading their book of secrets- hopefully the lessons don't fly over their heads, of course who knows if Cassandra's ideals for her reforms will match the reality or if spite from either the new mages and templars about the circle reforms being too half-assed to make any sort of difference will have a discouraging affect.
Then there's Leliana's reforms which everyone knows the common fears about radical change. Mage freedom can go bad for Thedas and only the Inquisition and her Seekers of Truth acting as Thedas' Spectres will be the last line of defense to keep the peace. Yes it will probably have problems, bad mages, fights with bigotted nobles, and the Inquisition or the chantry will either mediate it or leave it to their fate or crumble and let the next posturing tyrannical force take over and try to impose their version of utopia. But leliana imo does seem to appeal or call to the desire to be good- aspect of the Andrastian faith, the one that inspires where as the other two only dictates. Whether that will make a difference is hard to to tell.