The TNG movies were starting to suffer from Action Movie Syndrome before then, alas. The curse of having a big budget these days is that you get lots of focus groups meddling to try and give the movie "broader appeal." Plus, IIRC Patrick Stewart was also starting to gain a lot of influence at that point and made a bunch of demands to have Picard be more action-oriented.
Anyway. Basic point is that Star Trek has had an un-smart period, but once upon a time it was smart. And perhaps it's starting to get smart again, Strange New Worlds and Lower Decks have been quite promising in that regard IMO.
They had their moments. One thing I never liked about the show was how afraid the writers would get. They would stumble upon a horrible problem and just magic a solution sitcom style in under an hour. To be fair they did do it a few times. Borg and Picard. Nog and PTSD.