On one hand, it is quite conflctual with Roddenberry's ideals.
On the other hand, there are quite a few good characters and stories in there, if you ignore the religious/anti-humanist propaganda (and the Bajorans).

DS9 is basically the converse of VOY: VOY tried to build upon TOS/TNG, but was poorly executed; DS9 deliberately went against TOS/TNG, but received such quality execution that it just cannot be overlooked.
In the end, it's not the best, it's not the worst; it's middle of the pack and, like all Trek series, has great episodes and terrible episodes.

if it was humanist and anti religion, the TNG should have been your fav show of all time. And you should erect a shrine to Jean Luc.