It really depends on the reason the death is in the story. Is it there for good plot reasons, like some speculation around Harry's possible death and why it has to happen? Or is it one of those Joss Whedon-esque character deaths where he's utterly run out of new ideas and just kills someone off to set the story in a different direction (although that stops working, too, after the 5th story line concerning "character A reacts to character B's deathomg!!")

Some character deaths just piss me off, not because I'm attached to the character, but just because there was no reason for it (not even "I needed something bad to happen for no reason to make a philosophical point") except the writer's total lack of imagination