I enjoy a lot of sci-fi but could never get into star trek or *especially* Babylon 5. I think maybe because they're "slow" sci-fi or something, though I did enjoy the early seasons of Stargate SG-1 despite that format.
Yeah, Star Trek has always been a slower and more methodical sci-if show up until Discovery. However, there are quite a few episodes of TNG that have a lot of action. Q Who, Best of Both Worlds part 1 and 2, Yesterday’s Enterprise, Darmok, and All good Things are some of the best episodes for action. There are lots more episodes that have some action but it takes longer to build up to it. Deep Space 9 does have some earlier episodes that have a bit of action, especially the pilot episode that literally starts off with Sisko’s ship fighting the Borg from the TNG episodes Best of Both worlds. It does take a few seasons to ramp up the dominion war story line and has more action episodes sprinkled out until the finale of season 5 when the war actually kicks off. Then seasons 6 and 7 have alot of fast paced action episodes.
The movies also have alot of action. The Wrath of Kahn, Search for Spock and Undiscovered Country are the most action packed Kirk movies and then pretty much all the TNG movies are filled with action, especially First Contact. Also all the JJ Abraham trek movies are full of action as well. Beyond was the best of the new trilogy imo.
The best way I can recommend getting into any of the Star Trek series is to look up the top 5 or 10 episodes and watch them. That way If you don’t like those episodes then you know you won’t like the rest and have wasted alot less of your time.