That is difficult,but for me the first one i saw is my favorite-that would be Live and let Die. however that is a moore bond. I will have to think about the connery movie choice.
Timothy Dalton, he seemed to fit Fleming's Bond the closest and was a bit darker 007 than Sir Roger. As for favorite film, that's a tough one, I'd have to say "From Russia with Love".