If the character has a full, well rounded story arc, their deaths are sad, but understandable. I'm okay with that. I can accept it. If I really love the character, I may still look for alternative ways to keep them alive, even if it's not canonical. But I will respect the canon.
If it's something like the way Arcade abandons you after you complete his quest, then no. That has always bugged me about Arcade's story. "I'm sorry, but I have to go now, and never return until 5 mins before the end of the game". Seriously? WHY?
It's kinda like Legion's death. "I'm sorry Shepard, my people need me for some reason. *dies*"
It is cheap. A well constructed character death will make you sad and mad. A bad one will just make you mad and roll your eyes.