On top of my mind I remember one. Not exactly a sad moment but on start of Borderlands when Claptrap the Over Chatty Bot gets shot and is silent for second(!) I was sad there wasn't option to leave him behind. No you have to save him like you really care!