Foundation is probably the weakest of the lot! For All Mankind is good but gets too much drama and not enough tech later on, but it's still watchable.
There was no way to turn it into a television show without major rewrites.
However, Invasion is my call for the weakest scifi show they've done.
Do not watch.
No more slow burn mystery, with lots of character-based world-building, and protagonists out of their depth putting things together from a limited perspective (with the audience usually one step - but only one - ahead of them). The second season is action heavy, with characters reduced to tropes who seem to have had a knowledge download and all become "special".
I've seldom been more disappointed in a continuation of something I loved.