This is just a fascinating analysis. I never even heard of it as a trope by that name but I do actually like this trope (now that I know it actually is one). You listed several of my favorites in this. I probably enjoy it even more than I know because as I think about my original fiction a lot of it falls into this trope. Hmmm