It wasn’t Moore that made those Bond movies bad, it was the campy writing and filming.
Yes, Roger Moore as James Bond was saddled by poor writing and directing. The Bond genre was suffering from being in a rut when Moore played the role. Having said that, Moore was in a rut as well and he should have moved on and the series should have moved on. But it was a steady acting gig with some very hot young actresses, so why not?
Obviously the best Bond is Sean Connery, but I have taken a liking to Daniel Craig. There was a latent dark side to Sean Connery’s Bond, and it comes out more pronounced with Craig in the role.