Part of the issue with Trek is the tech is advancing to the point that you just can’t have a plot anymore. In the Berman era-you have at least three or four new kinds of FTL being developed-transwarp, artificial wormholes, I want to say jaunt drives(that’s in the novels I think?), and something else I can’t remember.*
Heck, Voyager had an episode with actual time cops from the 29th century. And apparently the federation was exploring other galaxies by the 26th century.
Before discovery ruined it all of course.
Anyway-people complain about technobabble but in the trek setting, tech is just that advanced that it can solve the problems in the setting 4 times out of five.
As a writer-you need conflict to actually have stories, and Trek’s utopianism(most problems solved, humans are genuinely more ethical, compassionate and curious than they are now) makes coming up with problems hard.
And most writers just don’t want to work within a framework like that-not even DS9’s Moore.
*Now I remember, slipstream.