Asimov is an ideas guy, his characters are all cardboard cutouts. That being said Foundation is terrible and it only gets worse as the series goes on, and on, and on. Every book ends with a Deus Ex Machina moment where the super smart scientists pull some shit out of their asses to prevail over the space barbarians. There's much better sci-fi from the same era.