Generally speaking
motive: negative connotation, usually used as \"why\" a crime has occured.
example: We hare a serial arsonist here. What was his motive?
motivation: positive connotation, usually used as \"why\" in an
accomplishment
example: What was your motivation in establishing this charity?