The first video game specifically that made me emotionally invested in its story:

Roxas: "Looks like my summer vacation is . . . over."

Goofy dies