Regarding Sir Roger Moore, I wouldn't want him to come to any actually harm, but his Bond was pretty much not good. On the other hand, if we are being honest, NONE of the bonds films were really good. They have only been various versions of eye-candy.
There is a Christopher Lambert film purportedly based on Beowulf that is astoundingly awful. Do Not Watch This Film. If prompted, I will tell you why; but I won't do it on spec.