I cared about keeping clementine alive in The Walking Dead, but I don't really consider it a real video game. It and Heavy Rain are interactive entertainment, but not video games.
I almost felt as strongly about about Yorda in Ico.
The new Tomb Raider was an emotional ride.
All the Mass Effect games are emotional and Halo 4 is as well.