I thought Foundation was great. A direct adaptation of the books would have been terrible, which is why nobody had done it yet. In case it helps, the companion podcast gives an episode-by-episode story of the changes - I agree with most of them, but can understand why they're controversial.
/joy of doing hard things intensifies