The first book in the original trilogy is a masterpiece, the remaining two is still good but not to the same high bar, and the same is true for the later additions i personally really enjoyed the first Prequel.

In terms of morality Asimov is quite forward for his time and still very relevant but there are sections that dates him a bit.

I haven't watched the show so i cant say if they are related.