Mass effect 2 plays heavily on the moral choices you make. It changes your appearance and your dialogue options. If you liked heavy rain then I know you don't mind long dialogue so I think mass effect 2 is right up your alley.
Heavy rain is unique on it's own. Try the Dragon Age series, it does a very good job at making you decide on certain events. Some you will see the effects right off the back, while others will come much later in the game or surprise you that they were even considered.
Fallout New vegas is a game that allows you to have so many different endings if you are looking for a great rpg game this is one that would probably impress you it has 4 main endings but so many other things are part of the ending you should try it