This is exactly the problem I also have with Marvel movies. Once you’ve raised the stakes so far it’s impossible to go back without seeming less than your predecessors. It’s why Iron Man worked so damned well as it was a pretty small, personal story… same for most of the early Avengers movies. Ever since Endgame it seems like everyone wants to either make it even bigger still (???) or challenge these people who have saved literally the entire universe with… emotional trauma? I don’t know… I’ve seriously lost interest.
RE: Silo. The books were good… the first was the best in my opinion and the quality didn’t shift too far in the subsequent books, but Dust was definitely the weakest (and last) of the three. Still consistently good, but I did find myself a lot less invested by the end of Dust than I was by the end of Leviathan Falls.
TV series I haven’t started Silo yet but it’s definitely on my radar. The Expanse TV show was really good and I felt ended at just the right point in the story.