I think Circe is a beautiful name and the character of Circe in The Odyssey has always intrigued me. I would definitely call my daughter Circe, though my wife might have other ideas.
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.