Post fall of Numenor, he loses his "fair form" though the fandom does debate a bit on what that means. But yes, he was originally attractive in canon and was known for using that to his advantage.