I always feel weird when people express joy over someone's death, no matter what they may have done or not

Same. A person's still a person, and I think the joy feels like something out of a story - like the evil king is dead or whatever, and the dead person stops being a person and starts being just a representation of their ideas or whatever.