Move over, 007. The daytime drama transformed the "Last Week Tonight" host into a new international man of mystery