I read the series as a twelve or thirteen year old and loved it, but when I tried rereading it a few years ago I came to the same conclusion.

As mentioned in another comment, it began as a serialized work, and it never really escapes Asimov's "make it up as you go along" style, resulting in quite a meandering series. I think it would have to be a very loose adaptation to make it interesting.