TNG is the most uplifting, imho, but as the others have said, the first seasons are hit and miss.
If you can make through the fourth episode, which is widely considered one of, if not the worst, whitout wanting to quit right away, you'll bei good, it only get's better.
If not, skip ahead to season 3. Also, everything looks more modern from seasons 3 onward, if the 80s look bothers you.
Here you go