I've since turned around on the intro and consider it to be the best one. Perhaps that's because I didn't know the song before, so it didn't have any prior associations for me. But still: the song alone doesn't work, but with the visuals, IMO it captures the spirit of Star Trek perfectly. The insatiable curiosity, the continuous efforts of hopeful individuals, the progress of science and technology, the dream to explore the Earth and then the Universe.

But it, like the show itself, only works in context of prior Star Treks. If this was the first show I've ever seen, I'd have balked at the intro and would probably be disappointed by the series.