Star Trek is great. Pretty much all of TNG is great, as is most of DS9 and even some of TOS (if only for the Kirk/Bones/Spock dynamic, the ridiculous campiness, and the occasional moment of a young George Takei going nuts). The movies for the most part may be underwhelming or bad for newer viewers unfamiliar with the series. You probably want to stick to Wrath of Khan and First Contact for starters; those are widely considered the best of the old movies, so you shouldn't move on to the others unless you first enjoy those.

The middle seasons of TNG were my favorite, IIRC, so enjoy. When you're through, I'm sure you'll be yet another unanimous vote in favor of Picard as the best Trek captain.