TNG put writing first. They went after interesting stories and didn't try to force them into a formula for ratings. Sometimes there was fisticuffs and phaser fire, but many of the best TNG episodes didn't involve violence at all. It was an optimist's take on the future. The cast of TNG was great, but Patrick Stewart's acting chops let them do episodes that another show couldn't have pulled off. He changed what was possible.

The quality of writing for DS9 was also quite good but, after trying the TNG formula for a season or two, they broke with the writing-first mentality and adopted an action sci-fi formula. The showrunners feared they'd lose ratings if an episode didn't have at least some action. It worked for DS9, but later Trek series have had a tough time shaking free of the action sci-fi formula. The problem with formulas is that, while they produce individual episodes or shows that are exemplars of their form, the sameness eventually causes viewers to drift away.

Strange New Worlds has shown it's willing to do some pretty wild things (e.g. turning its cast into muppets, adding gore and horror elements, etc.), but they have not messed with the formula in a meaningful way.

If you're looking for something outside the Trek formula, one recommendation I'd share is "The Foundation".