Usually, they're like the rest of us, no better or worse. But juries tend to assume they're better than the rest of us, leading to a culture where police officers tend to feel free to lie on the stand, which is a serious problem. Hopefully most aren't tempted to do it, but it definitely happens a lot.