Among all the lists that tell you exactly how many “types of story” exist, I like this one about the Seven Quests. No, I don’t mean the famous The Seven Basic Plots but this one in this more obscure, plain, and unsourced website: Love, Money, Power, Glory, Revenge, Survival, and Self. I don’t know the source behind it, and I don’t think it’s an exhaustive list —I can think of two other important motivations— but it’s useful, simple, and surprisingly powerful.
What I like about that list is that it actually focuses on human emotions and motivations, not abstract Jungian narratives like “Killing the Monster.” After all, what does that even mean? Killing it, sure,… but for what? Because you want to loot his treasure, revenge, or simple survival? It changes the story quite a lot whether the motivation of our hero is one or the other, and it also highlights the pitfalls of each motivation, its dark side if you will (Love -> Jealousy, Money -> Greed, Power/Glory -> Arrogance & Wrath, Revenge -> Obsession & Moral downfall, Survival ->? (this one is morally neutral as I will explain later.)