What does the scar from skin cancer vs mole removal look like?

Scar is a scar. Scars look the same, irrespective of the reason for surgery.
Size is key. The lesion is less important than the defect left after excision. This is more relevant tothey type of scar gievm that all other factors are the same.
No difference. The appearance of a scar is less dependent on the lesion that was removed, than the location on the body or face of the lesion, and the skill of the plastic surgeon who removed it. Hopefully, under favorable circumstances, such a scar can heal almost invisibly.