Any show that tries to paint the federation as less than aspirational has entirely missed the point of trek, and the product is a stillbirth.

Pointing out flaws, or highlighting the morally grey areas like ds9 did is fine, because it still preserves the federation as a multicultural utopia.