I was never real attached to him, and he smiled at the end which makes his death pretty touching. It'd be weird if he came back somehow. He should at BEST be in spirit on the aether or something and intervene to help you once or something. Nothing too weird though. But I think his heroism should be remembered by NPCs, and there should be maybe like a quest to pay respects.