Robert Maxwell wrote:
To sum up: principles that preserve and stabilize your society are worth keeping; principles that will get your civilization annihilated are not worth keeping. The series was never really willing to have an honest conversation about this. Characters and storylines vacillated back and forth on it, which may be true to life, but makes for lousy narrative.
I noticed that, too.
To me, the out ultimately seemed to be that it was "just a sci-fi show." In particular, the show was a re-imagining of BSG. Therefore, Adama at least and in particular had to be good and noble, ultimately, or else the show would divorce itself too far from the original to really deserve to be called BSG anymore. In other words, the important characters, at heart, had to be archetypes, because of the genre.
That meant the writers could play the Picard trope, "The line must be drawn here, this far, no further!" (Incidently, RDM was co-author for Star Trek: First Contact.