Sir Ian McKellen was the perfect Gandalf in Peter Jackson's The Lord ... One of the front-runners in the discussion was Sean Connery, best known for playing James Bond from 1962 to 1967.