Either when the last boss in Fable died (I thought he rocked :D) Or at the end of 'The Waters of Life' quest in Fallout 3- I even started yelling 'NOOO!!! DAD!!!" at the t.v., I loved him more than my real dad, lol
Apart from that, I usually laugh off every other 'sad' moment in games.