I started studying astrology as a teen, and have found that using sun sign astrology (the kind found in newspapers and magazines) is wildly unreliable.
When full charts are completed on a person, I can have a more accurate opinion of their appeal. For instance, I get along well with Scorpios and Cancers as a Piscean person, and the sun sign compatibility guides would predict great stuff for relationships with them. But I find that those relationships don't develop beyond a certain point and then they fade.
I guess I don't really take zodiac signs into consideration when I'm with people. There are times I will check out their signs, but I've never thought about whether or not certain signs are appealing or not. I do think my sign accurately reflects me...even though all the explanations are fairly generic.