I might have the oddest answer here.
Biggest turn-on that has absolutely nothing to do with looks? Trivia.
It sounds ridiculously cheesy, but if I'm watching Jeopardy! or at a trivia night with a significant other and she casually answers some obscure question that nobody else knows... BAM...