I have to admit I've never read any of the Foundation novels. Oh, I've tried—several times over the course of my life—but I could just not get into the story the way I did with DUNE.
Still, I was excited when I heard Apple was producing a series based on the books, and after seeing the trailers (latest above), I am pretty excited. It debuts September 24th on AppleTV+.
I read the series decades ago but unfortunately don't remember any of it. This looks very interesting. Too bad we don't have AppleTV+.