I will ask you two questions:
(1) What do you think the “consensus” view among SDMB liberals of Moore is?
(2) Do you think that O’Keefe and Moore are truly in any way meaningfully comparable?
In any case, a few points about Moore:
-As others have said, I wish he would cut out the deceptive editing, because it’s not needed and it weakens his point. That said, given the extent to which his movies are examined microscopically for errors by the right wing blogosphere, it’s definitely telling that what comes out is just deceptive editing whose level of dishonesty is debatable, as opposed to outright lies or fabrications.
-I saw F911. And it is not a movie which makes an argument for gun control. A lot of the responses to it make that assumption, and argue against it in that context. That is, they say something like “F911 is making an argument for gun control. And F911 says X. And X doesn’t really support an argument for gun control. Therefore, F911 is arguing dishonestly”. But it’s not arguing dishonestly, because it’s not really arguing for a particular point at all. It’s raising some points about the culture of fear in the US, and it’s certainly not a big fan of the NRA, but it is not saying “pistols should be outlawed”.
-The most lasting point any Moore film has left on me was the health care movie (Sicko?). And the point it made was not “we need socialized medicine” or “the US is a bunch of morons”. It was simply “hey, you know how health care works? The way it’s always worked? The way you get your insurance through your job, and if you lose your job you have to go on COBRA, etc etc? Well, it doesn’t have to be that way”. Granted, that may seem like a fairly obvious point, but I had just never really thought about it, and the movie did a very good job of bringing that point home to me.
-All that said, I’ve heard enough anecdotes like the one involving the book signing mentioned earlier to conclude that Moore himself is at least a bit of a douchebag.