For what it's worth, I've always thought the John episodes where he seduces women (particularly the ancient woman back in season 1) seem a little awkward.

It could be that all his sarcasm makes it seem like he's incapable of being sweet but he can be very, very sweet to Rodney and Weir. Hrm.

And you can't say no to Rodney. You just can't! ;)