My philosophy about killing characters or even just major changes in general has always been, Can you tell more stories with this change than without it? If so go for but I personally can't see many good story ideas coming out of Roy's death at Sanctuary, the idea of Sanctuary I think has a lot of potential.