I wasn't as emotionally invested but that was how I felt when L died in Death Note. I kept thinking "Oh, he's not really dead, he's pretending to be dead and he's going to come back and surprise everybody." When I finally realized he was not going to do that I got very uninterested and never finished reading.
Re: What is the most emotionally devastated you've been at a peice of media?