I like Star Trek the Next Generation the best out of all the different Star Trek series, and my favorite captain is Picard.
Yeah, I don't find 7 of 9 very attractive either. My favorite female characters from Star Trek are:
#1. Kes #2. Jadzia Dax #3. Tasha Yar