I've seen all Bond flicks and don't consider any of them 'great' movies. Casino Royal the best of them. Octopussy the favorite (due to it always being on cable back in the day). Skyfall the most overrated. A View to a Kill the weakest. They all have their moments. Some great scenes, some awful scenes, hawt chicks, cornball plots and usually very very bad humor. But, most are at least fun watches.
I'd like to see Cavill continue as Superman. But the guy wears a suit like no one else in movies. Maybe he can do both....