Kirk, Bones, and Spock are a pretty archetypal Freudian trio, and the execution was superb both in the original series and in the new film.

Nothing beats Picard, though. I'd probably agree with the ranking of TNG > DS9 > TOS > other Star Trek.