I must admit, that I cried like a little girl when Nana died in The Royle Family. Watching everybody say goodbye to her was incredibly sad...and they're all fantastic actors.
I occasionally get this in Desperate Housewives too; one particular example when Gabrielle confided in Lynette about watching her father die, and her being scared of Lynette's cancer. That was also very emotional.
