A man has died after being found unconscious inside a Sydney unit, with another man now charged with murder.