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.
The idea of psycho-history seems to be founded on a few larger ideas. One is that things happen in cycles: empires rise, get corrupted, and fall to be replaced by another rising empire. Maybe? Rome rises and falls. Spain rises*, then France and Britain rise, and eventually, Britain gets the biggest empire. Germany rises and falls, The the USA and USSR (though I'd contend the 20th Century USA and USSR are not colonial powers in the same way as the European powers were from 1500 - 1900).
*I've conveniently ignored 1200 or so years from Rome to 16th Century Spain.