Connery was great in Hunt for Red October. I can still see him standing in the conning tower as they sailed up Penobscot Bay.
The Man Who Would Be King is my favorite non-Bond Connery film.