No. He won't come back -not like Nick, anyway. I look for him to have some influence through his photo is his old office, but that is it, unfortunately! I'm gonna miss him! He certainly was not afraid of death. As to knowing more about the horcruxes, he may have had some vague ideas, but they were not solid enough for him to pass that info on to Harry or he definately would have done so, I think.