charmer

ˈtʃɑːmə

noun

a person with an attractive and engaging personality, typically one who uses this to impress or manipulate others.

Joe, who had been such a charmer, had become irritable and lazy