IMO the plot of Apple's "The Foundation" is an infuriating insult to the original series. However, the production is great and Lee Pace is awesome as usual.
I kind of love it when movies/TV don't follow the books too closely. It means more content in a world I enjoy without repeating too much.
I think it's best appreciated as an original space opera that just happens to have the same name, especially given that so much of the show is genuinely original.