You are right user, the last books are complete shit. It turns into Lost in Space sort of story. The first few are absolute gems, and then they sort of go bad. The reason is actually interesting. Take a look at the publish dates:
The Complete Robot (1982) and/or I, Robot (1950)
Caves of Steel (1954)
The Naked Sun (1957)
The Robots of Dawn (1983)
Robots and Empire (1985)
The Currents of Space (1952)
The Stars, Like Dust (1951)
Pebble in the Sky (1950)
Prelude to Foundation (1988)
Forward the Foundation (1993)
Foundation (1951)
Foundation and Empire (1952)
Second Foundation (1953)
Foundation's Edge (1982)
Foundation and Earth (1986)
Notice the dates? Basically from my understanding, is when he wrote the originals, he didn't make too much money and some ((( intellectual property troll ))) kept rights to his work so he couldn't continue writing the series. Then after like 30 years, ((( Issac Asimov ))) got permission to continue the series which he did. But 30 years is enough to change a man so the nature of the story would soon follow.
Here's what I've read if any user is interested d/l them from youtube and listing to them in their car/ making food/ waking outside/etc:
Isaac Asimov - Foundation
youtu.be/_hDsujeDsak
Isaac Asimov - Foundation and Empire
youtu.be/Do9ZF85BHnE
Isaac Asimov - Second Foundation
youtu.be/ZwGRlJKz6FM
Isaac Asimov - Foundation's Edge 1
youtu.be/0vfxEnZ43Gk
Isaac Asimov - Foundation's Edge 2
youtu.be/kalXOejQASM
Isaac Asimov - Foundation and Earth 1
youtu.be/df5vjvzDHTE
Isaac Asimov - Foundation and Earth 2
youtu.be/nzp18FH36to
Isaac Asimov - The Caves of Steel 1954
youtu.be/X4c06cQNlkc
The Naked Sun by Isaac Asimov complete // unabriged.
youtu.be/wlwwgbCf1Pc
A Canticle for Leibowitz by Walter M Miller Audiobook Unabridged ©
youtu.be/gLGGZh-KYgI