The books are awesome. The concept of being able to (more or less) predict the future and trying to shepherd humanity through various crises that will alter the timeline and trying to rescue us from our own nature is a fun one.
The nature of the story doesn’t lend itself well to adaptation in a visual medium but the show is decent (it does deviate some from the books and mess around with the timeline some to make it work better for TV). Can’t speak to the movie.
The Foundation Trilogy also was published 1951-1953 and you see a lot of ideas that became mainstay scifi tropes in their early form. For example, it’s easy to see the influence Foundation had on Dune.










I think it’s a touch more nuanced than that but yes the plot does follow Hari Seldon’s creation of a school of thought and study called psychohistory.
The main plot is that humanity would be plunged into 30,000 years of dark ages full of bad shit but Seldon believes following his plan it can be shortened to only 1,000 years of real bad times for the schmucks born then.
Like you said, one of the themes the books talk about is the paradox of knowing the future and if you can or can’t change it. If you know the future and do something to change it to be different from what you predicted - does that mean you did or did not actually know the future?