That's a pretty broad question. What sort of RPGs are you talking about? Are you asking about how storytelling works specifically from a turn-based RPG standpoint? Because you can write just about any story in a turn-based RPG and have it work, so long as your writing execution is up to par.
Edit: Weird. That herculean effort took me only twenty seconds to find this.