You can't go wrong with the Sean Connery/Roger Moore era Bond movies. Pierce Brosnan wasn't that bad of a Bond either. Haven't seen the latest movies with Daniel Craig yet.
There are too many to rank.
I agree, I have bought all four James Bond Ultimate Edition DVD Box Sets and it didn't come with the original 1967 version Casino Royale. There are so many good James Bond movies I like and I can't put them in order yet and there some Bond movies, I haven't seen yet.
That's not a Bond film, it was a Bond parody. The people that own the Bond franchise finally did the Fleming novel justice by making the film a good forty years after the fact, but the original was a comical farce that was a disaster of a film in many respects.