It has its moments. Season 3 and 4 are better than the first two. It takes a while for any show to hit the tonal balance that makes a good trek. One thing that I think the show does well is fill in the gap between “humanity is a bunch of selfish messy bitches who would prefer to annihilate each other rather than get it together,” and the humanity we see in future series. You’re watching them become less xenophobic, more open minded and inquisitive.
Skip the finale, the episode before is a good finale.