I confess I haven't read all of his work on robots, but actually (perhaps contrary to popular belief) Asimov was hopeful on robots from the start. His very first short story[1] and one of the first stories about robots (after RUR, which is amusingly and maybe unsurprisingly both the story to coin the term Robot and already feature a robot uprising!): it's essentially a touching friendship story between Gloria and her robot Robbie.
I wouldn't say there's no AI risk, or risk from having robots and powerful intelligences, but he generally seemed to convey that we should be capable of making quite safe and quite friendly robots, given that we can make them at all. Which makes sense to me. The engineering of ethics in robots and AI doesn't seem too much more alien than the task of engineering AI itself (specially goal-oriented AI). It requires effort, attention to detail, and a progress in understanding morality and ethics that is going to be difficult for us, but it shouldn't be that fundamentally scary, as long as we collectively have the will to make them safe (in the spirit of the three laws).
I think Hollywood (in 'I, Robot' the movie) exaggerated his impression of AI danger (perhaps because of the 'Frankenstein complex'[2] Asimov coined), and the interest in catastrophe. I think 'The bicentennial man' is a complementary movie more in the hopeful spirit of Asimov.
[1] https://en.wikipedia.org/wiki/Robbie_(short_story)
Quote: " The story centers on the technophobia that surrounds robots, and how it is misplaced. Almost all previously published science fiction stories featuring robots followed the theme 'robot turns against creator'; Asimov has consistently held the belief that the Frankenstein complex was a misplaced fear, and the majority of his works attempted to provide examples of the help that robots could provide humanity. "
[2] https://en.wikipedia.org/wiki/Frankenstein_complex