I liked all of the movies except Clear and Present Danger, with Hunt For Red October and Sum of All Fears being very good and Patriot Games being okay.
As far as Clancy books, I love most of them. My favorite is Red Storm Rising, not a Jack Ryan-universe book. Hunt For Red October was also very good as well as The Bear and the Dragon. Rainbow Six is okay so far.
On the other end of the spectrum, Cardinal of the Kremlin and especially The Rabbit sucked.
I want to read Sum of All Fears next.