Asimov's own introduction to the books talks about how little action there is. I don't have it in front of me, but here's roughly what I remember reading: There had been a long gap between when he wrote the first book and when his publisher tried to get him to write more material. He needed a refresher, so he re-read the original stories. And as he read, he kept waiting for something to happen but nothing ever did!
Despite that, it was a compelling story and he obviously wrote a bunch more. But why would you make a TV show or movie out of it? There's almost nothing in it that's more compelling if you see it instead of reading it.