The Borg are creepy to me because of the idea that they can take away your individuality and turn you into a cold blooded cyborg. The loss of ego. The loss of "I am" is a terrifying prospect. At least to me.
Now if only ST crossed over with Animorphs, and we had Yeerk controlled Borg walking around...YIKES!