I always talk about this and also have the feeling no one knows about it. In any case I think I read somewhere that the idea was going to be along the lines of "right before you die you have a moment of clarity where you know everything, John had had a boating accident that led to that moment and he came back from the death". Honestly knowing what the future looked like sometimes I'm almost glad it got cancelled, because I think that would have been a bit of a boring explanation.

I think about that last shot, looking up at the bartender all the time. Weirdly the only other thing I can think about the main character being in is blade 3.

That sounds like a cool premise!