I have also been struggling with this, both in storytelling for my kids, and in trying to make interesting YouTube videos.

Lots of people on YouTube seem to recommend Save the Cat by Blake Snyder. My experience of it is that there's some useful ideas in it, but it's overly formulaic.