These recurring patterns are called "tropes", there is a wiki of them: https://tvtropes.org/
A long analysis of Stargate SG-1 as starting point: https://tvtropes.org/pmwiki/pmwiki.php/Series/StargateSG1
A long analysis of Stargate SG-1 as starting point: https://tvtropes.org/pmwiki/pmwiki.php/Series/StargateSG1
1: https://tvtropes.org/pmwiki/pmwiki.php/Main/TheHerosJourney 2: https://tvtropes.org/pmwiki/pmwiki.php/Main/Kishotenketsu