You identified one very important problem with Foundation that is present in the books and in the series. The story gives us no reason to care for the characters. I've written an article about it, you may want to check it out.