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.