I think a good analogy may be... I have, in my life, talked my way out of getting mugged twice. Wasn't something I planned. It was just how I responded to the situations. Somewhere early in my life I internalized, from somewhere, de-escalation as the first approach. This ties in, through hindsight, with the sorts of things I gravitated to later, like aikido and very counter-strike-y techniques of kendo and European fencing. I don't instigate or escalate, under most circumstances.
That is the big difference I see between both the different eras of Trek -- and their respective audiences. TOS was on during the Cold War and when VietNam was reaching its height. A show that showed people from all over the planet cooperating in peaceful exploration, using force as a last resort, and only when other avenues had failed, striving for diplomatic solutions even at personal risk... That was very appealing, especially to the younger crowd. TNG debuted late in the Cold War, as relations between USA and USSR were thawing, if you will -- and, in fact, the Cold War ended during the show's run. The Soviet Union broke up and the Berlin Wall came down. So the setting of that show being one of a relative "Golden Age", where the Federation was at peace -- the Klingons were our allies, the Romulans hadn't bugged us in ages, relations with the Gorn and Tholians had mellowed, border skirmishes with the Cardassians had resulted in a diplomatic solution... Things were good, all around.
Even DS9 and Voyager leaning more into conflict than cooperation was more or less accepted (not by all, but by many), because the underpinnings of core Starfleet (and, by extension, presumed Federation) values was still there.
Enterprise... I try not to talk about much, because it doesn't really fit. That was my first big sense of things falling apart, truth be told. If they hadn't gone with such bad uniform and set design, that would have made an amazing TOS precursor, in the 2240s. For something in 2150s, given what the extant canon had established, it doesn't work. The Temporal Cold War was a bad idea. I have wanted Trek to minimize time-travel stories, because they use conflicting mechanics, and ignore the paradoxes they introduce. So basing the throughline of the first couple seasons of Enterprise on time travel? So very nope. Outside of that, it works reasonably well as a precursor to either JJ-Trek (and a model of that NX-01 is in Admiral Marcus' office in Into Darkness) or the Disco-verse, which also doesn't fit with the Star Trek canon established from 1966 to 2001.
Picard, so far, is slightly behind Enterprise, IMO, while significantly ahead of Discovery. There is some good material in there, some good moments... but surrounded by way too much utter garbage. It makes me sad, because -- *shrug* -- it's Star Trek, I've loved the setting for most of my life, and I want to love anything new that comes out, because it's Star Trek... Except it isn't. I do not see professionals acting professionally. I do not see Humans acting humanely. I do not see crewmates treating each other with basic respect. I do not see much conflict resolution beyond, "If brute force doesn't solve your problem, you're not using enough". Which fits some fictional universes, but shouldn't be a part of Star Trek.