Rory is a boys' name to me, and I love it. It's the name of one of my sons, and was very unusual in the UK when we picked it. 'Red king' is the meaning, so for me it doesn't work on a girl at all. Actually, I'd go as far as to say I strongly dislike it on a girl.
Aurora is pretty, though.