The quests allow for more meaningful and various choices. Save Redcliffe or don't. Affects how you infiltrate the castle. Have everyone fight for the village, or don't. Keep everyone alive during the battle or fail. All result in something. Take over Floyd's tavern, or give it to Bella. Let the Redcliffe knights in to the courtyard to help fight the revenant or keep them out. Save Connor or don't. Sacrifice Isolde or don't.
Side with Harrowmont or Bhelen, or play both sides. Side with Caradin or Branka. Have Shale with you or not for extra storyline.
Save the Circle or annul it. Annulling it closes off options in Redcliffe.
Poison Andraste's ashes or don't. Consequences if you do.
You can also lose the Landsmeet. Can't lose against Corypheus.
Many other examples. Too many to post.
You have some choices in Inquisition, but they never amount to anything. There are no consequences.
I was pretty satisfied with action-consequence in DAI.
1. Choosing Inquisitor's race affects the way you see the crossroads, affects court approval at the Winter Palace, affect the conversations more than in Origins.
2. Siding with mages vs siding with templars. It must have consumed a crazy amount of resources.
3. Ur decisions might cause companions to leave the Inquisiton.
4. Loved the Vir'Abelasan and the conseuquences of drinking from it. WOULD LOVE to play the Inquis again and see if Solas will use it against u, IIiIiiiiiiIIIIiII !
5. Hidden scene if you play Assquisitor - HILARIOUS!
6. You get to chose who rules Orlais and who becomes the next DIVINE! Just wow.
7. Since we know that DAI was splt in two to cover the whole story, then I am sure that DA4 will carry more consequences from the previous games. With DAO it was like: you made a choice but you did not feel it impacting DA2 or DAI much :/ ... That is why I believe in keeping the same protagonist - you can actually feel long term consequences.
Ok... I know it's nothing. But there is one consequence that I really love... Every time I go to the Winter Palace I jump on furniters and on people's heads and watch my court approval drop :3 ... Love it...