Foundation is OK. Lots of special effects. It is NOT the Asimov story.
They put characters in the same time period and made two of them female. Which changes the story. They also made the story of the Creons a major storyline when in the original works it is a minor part of the story. Which I just don't like -- I am sick of stories about royalty.
But the oddest choice is to make the robot character - who should be Daneel, a character that spans the whole Foundation and Robot book series - a female character who kills two humans breaking the first law of Robotics.
An OK Si-fy series but NOT the Asimov story.