In Dragon Age, you could be faced with the decision of losing your main character, killing Lohgain, or losing Alistar. Plus there were other additional story paths that could result into a different outcome. You may decide to kill the dalish elves or the werewolves or save them both. Either way, these types of games provide consequences for the player.
The wrong choice could lead to an outcome a player may regret, adding more attachment and thought to how players wish to play the game. Not to mention it adds more replay ability as players may wish to play the game again to see the different outcomes of other choices.
In truth, I find it rather annoying when games try to establish pseudo consequences’, meaning the game makes you to believe that your choices matter but in the end, no matter the choice the outcome is always the same. This is why I never really enjoyed Mass Effect 3 or Dragon Age 3 as much as their original predecessors.
In Mass Effect 3 the entire game builds upon the premise that if you do not make the correct decisions you could end up with a bad outcome, not saving humanity or possibly losing your entire squad or crew. Sadly, this is false, no matter the choices you made Sheppard always end up the hero with little to no real sacrifices, or perhaps sacrifices did occur but were not based on your decisions (i.e. the death of Anderson).
There are many RPG games out there that provide players with consequences or rewards, games like XCOM, Divinity Original Sin, FFVII, Dragon Age Origins, Mass Effect, Mass Effect 2, Skyrim, and many more. If you ask many gamers if they enjoyed these titles, most will say yes they enjoyed these titles, not just because of their story but because they had different variations of outcomes that was based on their choices. I mean the games are really what they are, role-playing-games. Players can role-play a character and have different outcomes based on the way they played their character(s).
For me this is what role playing is all about, being faced with choices and having different meaningful results based on the way you choose to play your character. Otherwise without the possibility of choice and consequences, the game isn’t an RPG but really just an action, drama, or horror game, which really feels more like watching an interactive movie than being involved in an interactive world.