That’s right, the TV show has practically nothing to do with the books other than some character and place names and the general idea of a declining emprire and its emerging remote colony.
I decided to not watch the Foundation series because I was worried that the concept would be butchered. I watched Man in the High Castle (based on Philip K. Dick) with very high expectations. Dropped it after the first episode. The book was strange, dark and psychedelic. It was clear that the series was not made in the spirit of the book.
I guess its a good thing that I decided to skip the Foundation series.
No idea regarding automation, but you can get (some) 4K TV series off rutracker (a public tracker).
https://rutracker.org/forum/viewforum.php?f=119
The site itself is in russian, but search queries in English work perfectly.
Content from English speaking countries almost always (literally around ~99.9% of the time) includes the original English audio track. You will have to manually set language priority in your video client as russian audio is set as the default track, but this should be easy to do.
Keep in mind that non-English movies/series will include the original audio and a russian dub/VO, English dub/VO will not be included. English subs are typically provided for non-English content.