I hope he stays dead. Any resurrection would cheapen that final scene.
I'm the complete opposite. I'd feel that his death now would cheapen the whole experience and make it all feel pointless, while taking away one of the last few likeable and interesting characters left in Westeros. I think he's way too important to take out of rotation after five seasons of building him up. I know the books and the show are about challenging those kinds of storytelling preconceptions, but sometimes the audience deserves to have their loyalty to a character rewarded too.
BUT -- I'm sure I'm not the only one that remembers Ronald D. Moore and Katee Sackhoff giving "candid" interviews about another character's death a few years ago here.
Hell, just this season, the
GoT showrunners might have pulled a minor rope-a-dope by listing Joseph Mawle (Benjen Stark) in the casting notes for Episode 8, leading fans to believe he might show up among the Free Folk or as a White Walker, and then he never appeared. And then in this episode they played that Benjen clip in the "Previously On..." segment to give you the impression he might be coming back again, only to have it serve a completely different purpose. So while they're not playing JJ Abrams level obfuscation games, they're not above a little audience trickery to build excitement or preserve a storyline.