Read it when I was about 10 and thought it was great.
Tried to read it again 20 years later and was unable to get more than 100 pages in.
From what little I remember of it, I suspect it will not be very well suited to cinema.
I think it could work because Asimov has created a universe with strong characters, lots of plot threads, and an underlying mystery.