Regarding your discussion of the Foundation TV show: any book as old as Foundation will have a number of problematic ideas. There were a number of places where I think the show made bad decisions because it was struggling with how to adapt these for a modern mass audience. To keep this post to a manageable length, I will limit myself to two of them.
First, empire and colonization were not considered bad things at the time Asimov was writing these stories. In fact, countries in Europe were still bragging about their colonies, and England would still talk about things like “civilizing India”. For anyone who thinks that Americans didn't have these attitudes I would recommend Daniel Immerwhar’s excellent book “How to Hide an Empire”.
Second, Asimov wrote these stories before chaos theory as we understand it had been developed. So, the idea that one could statistically predict the future of a society would not have seemed strange to people at the time. Actually, Asimov kind of threaded the needle of popular ideas by positing that one could predict the future of a society statistically and still leave the free will of an individual intact. However, in a world where movies such as Jurassic Park popularized chaos theory, and shows such as Star Trek TNG popularized Heisenberg's Uncertainty Principle, presenting Psychohistory as it’s shown in the books would ring false now.