You can definitely see the (lack of) budget, even though it was expensive for TV at the time. Those foam rock sets with a painted background, entire episodes set only on the bridge, etc. But the camera work, steady, graceful movements, the deliberate pace to the action, the WEIGHT of a phaser shot and the implications when it hits, a deliberation about what to do but the decision is Picards alone, all those things are so good. They set up moral quandaries and social debates in clever ways to give a bit of representation "to both sides", do a little debating about the merits of each, and then come to a conclusion that often doesn't feel spoonfed (though sometimes its way to nice and easy). Characters rely on the quality of the actors performance and a few key characteristics to resolve conflicts, they are not all "look at me! virtue signals". Coming from TOS which very much felt like the "Kirk/Spock/McCoy boys club" to a wider ensemble that still had a definite hierarchy and each person was still aspects of a whole with a shared vision. Lately it seems the crews are either totally fractious and at each others throats (personal drama all the time!) or whiney bitches who shouldn't be trusted with a garbage scow, much less a multi-trillion credit starship. You can see the lack of proper guest stars on shows like SNW where the crew can do EVERYTHING, any guest star "local alien" is there purely to create a problem, not to exercise any autonomy of their own or force the crew to make any hard choices or even explain their own culture (usually Uhura gets all those lines).