I'm usually loath to reference bearers of different spellings, but the cruel and insane queen of the "A Song of Ice and Fire" series, written by George R. R. Martin, bears the name Cersei. Just in case anyone needed more encouragement NOT to name their child this. :P
Circe was a minor god in the Greek myths who turned men who came to her island into pigs and other creatures befitting their nature (but they were mostly turned into pigs).
Honestly... I think this name is all kinds of awesome. It sounds really cool (at least, I like SUR-see, though I understand it's not everyone's cup of tea), looks really cool, belonged to a powerful character in Greek Mythology, and was used in the Toni Morrison novel "Song of Solomon."
Parents would definitely need to be thick-skinned to name their daughter Circe. I don't think it's quite as stigmatized as, say, Jezebel, but it would still be a challenge.