I've read a fair number of science fiction novels over the years, but I never got around to Foundation and I don't think I've read any of Asimov's other books.
I got hold of a copy of Foundation and I was surprised how short it was. Like a lot of sci-fi novels of the 50s and 60s, although set in the future, it's kind of dated at the same time. I enjoyed it, but it's far from the most thought provoking novel I've ever read. I have the rest of the series, so I may read them too.
I also recently re-read Dune, which I had originally read in my early teens. A couple of things occurred to me, while both these novels are set in the far future, with advanced technologies, faster than light travel and a human civilisation spread across multiple worlds throughout the galaxy, they both feature a feudal, aristocratic system of government, with emperors, barrons and dukes, which in the present we might consider a more antiquated system. Odd that both Frank Herbert and Isaac Asimov are both from the US, a nation that fought a war to free itself from aristocratic rule.
With regard to Dune, I was also struck by parallels between the story of Paul and the Fremen and T.E. Lawrence and the Arabs; I wonder if Frank Herbert ever read the Seven Pillars of Wisdom.
I've seen the first three episodes of the TV series and I agree, so far, it's only very losely based on the book. However, I did see one review which suggested that the book wouldn't translate very well to the screen unaltered and I'm inclined to agree. Beyond the first chapter or two, the book is essentially a collection of short stories. While everything relates back to Seldon and the Foundation the book keeps leaping forward in time and we are constantly introduced to new characters. I understand the decision to have some characters, in the TV version stick around so that they can become a constant throughout the series.