For me the idea of getting anal sex is a turn off, mainly because when I think of it I think of it as a "gay" thing for a guy to do.
But the thought of giving a girl anal is a turn on because its something a little taboo, something new, something different, something you don't get all the time, it makes it exciting in a way.