My only beef with Foundation, is calling it Foundation.
When I watched the LOTRs movies, I recalled several saying that it diverged from the books. And sure, it did. It had to. You cannot convert mediums and not have change. Yet the easy way to conceptualize it, is that you're listening to two different people's telling of the same tale.
Both people will perceive the world as a different place, will even be standing in different places during events, may not have been at all events, and so on. Once that's in the pocket, a movie such as LOTR does quite well I think. It captures what it should.
But move to Foundation, and I really have no idea what book anyone read. I feel that someone read the books, and wrote a 1000 word summary of it... then someone used that to write the scripts, which was heavily edited. Massive, vastly important concepts are completely dropped from Foundation. It's not even remotely the same story.
Again, it's not bad. I just hate they stole the name, and character names.
The reason I'm on about this, is that the people designing sets are typically "touchy feely" types, which is of course fine. However often these types have a really hard time with static, unchanging facts or things, very specific details, and caring about function over form. This of course can extend to world building by an artist, as opposed to a sci-fi author.
Here's one example... in the books the Empire had 25 million planets. In the series it's under 10k galaxy wide. There's no real reason for the change, other than "don't care" or "Oooh, that's a confusing number". Even the size of the galaxy was off in series 1.
So when it comes to sets? Bear in mind these people think "Ooooh, space!" and go into a flutter of excited re-design. They're not approaching it from an intellectual perspective, but instead from emotion. And space is strange, and cold, and blah blah.
Perhaps I'm unkind, I've met artist types which were more cognitive of their art. Sometimes. When they were drunk.