Definitely,he has shown so far that he's leader material.Although when it comes to more personal moments he might retain his shyness and awkwardness.
Hm, I don't know. Now, after all these years, I look back at him, and things he said have different meaning.
Like, when during Broken Circle he says that he wants you, and all your party starts giggling, and you all are "AWKWARD, AWKWARD!", he says, when he realizes that he just kind of confessed, that he doesn't care anymore what you think. I think he went through revaluation of what's important in life.
And in DAII I think he was just being polite when he called prostitutes "young ladies", because he's extremely polite in DAII. Remember how he writes his letters? Yeah, he's like an Avatar of Politeness.
So I won't be surprised if, when your Inquisitor lures him into bed, he will silently undress, and calmly asks for instructions... I actually hope BioWare won't show this, because I want some food left for my imagination. 