Don't be afraid of your characters failing
I’m writing this after playing Heavy Rain on PS3, which is not a roleplaying game in the sense we’ve come to use the term today. But it’s definitely a game where you assume the role of different characters. The game is like a film, each scene you assume the role of a different character who has their own story, and each story overlaps with every other. The way this game is a bit different to other games I’ve played is that each character can die, and the game continues. The story is just dramatically altered because you can’t ever see the continuation of that character’s story, and any scene that includes them from that point will be different.