I really like Aurora and I love the meaning. It's unusual where I live so I don't see it as trendy. I dislike Rory as a nn - I see it as a rather nice boy's name and can't get my name around using it as nn for Aurora.
I wouldn't use Aurora because I am so in love with Aurelia though.
I like Aurora Temperance with the occasional nn Tempy.