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.
The new Tomb Raider was an emotional ride.
All the Mass Effect games are emotional and Halo 4 is as well.
Are the adventure games of old not video games? Like Monkey Island