I heard that the first season, or at least the first half of it was slow to get going and that it picks the pace up later on; may have to test it.
Star Trek’s another classic I haven’t watched much of, the only ones I can remember are the NuTrek movies, the Wrath of Khan one and the first two seasons of Picard.
I haven't seen them, but from what I hear the first two seasons of Picard are some of the worst Trek. So, the only way is up.
TNG. When I did a proper watch through (not just seeing random episodes), I started at season 3 and went back to Season 1 and Season 2 at the end. S1 is bad, 2 has some good episodes, but you don't miss a huge deal. Seasons 3-6 are just quality episode one after another. It's episodic but tackles moral, ehtical issues and Patrick Stewart is just great.
DS9 is probably the most consistent series. I see a lot of people say it starts slowly but I enjoy the building arcs it has. It has a different dynamic, being closer to modern TV with longer arcs. It has some of the best characters there's been in any Trek (IMO). Although season 7 is like a massive drop off (just like when, in TNG, Dr Crusher
).
The original films are good, I'd actually recommend them as a starting point. Although, the first one is VERY VERY SLOW. I remember watching it once and it felt like I fell asleep for two hours, woke up and it was the same scene. 'They' say the even numbered ones are the best, which is probably true, but the others have some interesting ideas if not always well executed. Wrath of Khan feels like the template for too many Trek films and actually a lot of big blockbusters. Sadly, no one seems to be influenced by 4, which shows how you can make a great adventure film with no/an indifferent antagonist.