If you want to write a good novel or script, I'd suggest creating a sympathetic protagonist with an urgent problem that they are forced to confront and despite their best efforts things only go from bad to worse but then they draw upon their inner reserves and turn things around at the last moment.
Successful narratives can usually be broken down into a series of story events - which are permanent status changes for the characters, not just random things happening with no consquences - like "the protagonist is betrayed by his/her brother because of jealousy" - and have these connect together in a way where each event naturally flows from the previous one.
If you want to write a great novel or script, you can throw out the rules and create something totally original.
Or did you want to make an RPG campaign with the potential for a good story to emerge? That's a whole different process.
I've recently discovered that one of the things which really causes me to like (or dislike) a work of fiction is the minor characters, on in RPG terms, the NPCs.
On Golarion, for example, we got a lot of mileage out of Freyr Darkwine, Achille Parsall, Vencarlo Orisini, and Trinia Sabor.
There is so much written on this that it's scary.
A good story puts a character people can relate to (not necessarily a likable one) in conflict, following a rhythm of rising and falling action, set in an environment people can (again) relate to. We like to read about what we know, spiced with enough that we don't that it's interesting. Good stories deal with love, bravery, danger, death, and triumph. Good stories carry themes that resonate with readers, without being blatant.
Great stories are far more complicated beasts, and each one is unique.