I can't get enough of these in the literal sense that I barely find them:
-Children and YA books in which parents and adults stop being just an annoyance and start helping the protagonists (without replacing them even though they are more experienced). E.g. Elatsoe
-Convincing others to help not through violence (in the more general sense) but through compassion. E.g. the way everyone helps Grogu in the Mandalorian or Piccard in Star Trek: Piccard.
-The feeling of hope in the world, that you don't need to do everything yourself because there are other good actors in the world. E.g. Animorphs and The Lord of the Rings.
In the same sense: books for adults with kids that are actually kids, not mini-adults, not incredibly smart, not wallpaper, but real kids of any age. I don’t think I can remember the last time I read something like this. E.g. ‘Do not let me go‘ by Kazuo Ishiguro
Doctor Who is good for the second one too, that's basically the Doctor's whole deal that they never carry a weapon and just try to talk their way through everything. Although they will fuck someone up if they get pushed too far lol.
Have you read the moai island puzzle by Alice arisugawa? Fits your trope perfectly and even tho the English translation was wonky sometimes, I thought it was a good book
I recently finished Station Eleven and honestly thought it was a bit boring. After that read I was put off of that author. Is Sea of Tranquility on par with Station Eleven? Should I reconsider?
Anything where the protagonist gets to build a new world in a virtual environment, or significantly modify themselves by using virtual environments. Examples: "Fall, or Dodge in Hell - By Neal Stephenson" and "Accelerando - by Charles Stross"
spoiler
Dodge in Hell - where he is uploaded into a host system that has only a very basic physics model and nothing else. He gets to create the world by experiencing it, and remembering what things 'feel' like. Such as inventing gravity by watching a leaf fall to the ground and it feeling right.
There are a few series that I can read over and over. Nero Wolfe by Rex Stout. Travis McGee by John D. MacDonald, and Easy Rawlins by Walter Mosley spring to mind.
Mosley's books are outliers, because Easy changes with time. McGee and Wolfe remain perfect examples of the sort of life most of us dream about.