A lot of tension in a story happens when the characters do something against the wishes of the audience. This isn’t really possible in the context of an RPG, because the characters ARE the audience.
It pretty much means you can’t create moments like the one where (in the books, mind you) Eowyn begs Aragorn to let her ride with him into battle, and he refuses because he has no right to accept. If you try, you’ll end up with nonsense like what you see above, because 90% of the players out there will simply let her join without a second thought. The other 10% will try to have sex with her first.
Why I Hated Resident Evil 4
Ever wonder how seemingly sane people can hate popular games? It can happen!
This Game is Too Videogame-y
What's wrong with a game being "too videogameish"?
The Death of Half-Life
Valve still hasn't admitted it, but the Half-Life franchise is dead. So what made these games so popular anyway?
A Star is Born
Remember the superhero MMO from 2009? Neither does anyone else. It was dumb. So dumb I was compelled to write this.
The plot of this game isn't just dumb, it's actively hostile to the player. This game hates you and thinks you are stupid.