As someone who just read the foundation series for the first time, I think you’ve missed the point of the books. Others here correctly point out it isn’t character-driven narrative, it’s exploring major philosophical and social questions. How reliant should we be on technology, for example. How do societies undermine and eventually destroy themselves? It focuses on the social body writ large, not a particular hero. It’s a wonderfully creative, exuberant, intellectually curious imagining of future society, the inevitable decay of everything we build, and what it means to be human (ex: should we merge with gaia?).

I’d also add that you’re not giving the series enough credit for how innovative it was when it was published. It shaped the entire genre of science fiction, including some of the most famous, beloved sci fi series like dune. At the risk of being intellectually lazy, I’ll say that if all these great, thoughtful writers found something wonderful in Asimov but you didn’t, it’s more likely you’re missing something, not them.