>>2445TOS and TNG were definitely utopian and even communistic especially for its time (Cold War). DS9 was still utopian, explicitly so, with the AnCap Ferengi and the Dominion-Cardassian war as a fascist threat as a foil for the Federation's utopian ideals - this leads to more "pragmatic" decisions that abandon the moral order of the Federation,
In the Pale Moonlight is basically the incubator lie turned on its head. VOY is basically rehashed TNG without the utopianism, as Janeway makes some very questionable decisions too. The crew would treat The Doctor, a sentiment program, way more disrespectfully than Data, although there are some episodes that delve deeper into that relationship like
Latent Image. ENT shows the ascendance of humanity from their archaic roots into a communistic space federation, they're already pretty advanced but there are still problems like militarism and racism which they need to overcome - the problem is, the series is just a bit boring.
NuTrek as mentioned is woke politics of Twitter with neoliberal undertones (they praise Elon Musk in Discovery and in Picard they treat androids as a slave race).