The end of a great game or seeing a game get cancelled?

The last two weeks got me thinking. Gamespot breaks it to us, that some great games got cancelled over the years and "Reality Check" shows us why we are sad after finishing a great game. My question in all this is what's worse?

A great game, that sticks so good to your memory, that you can't even replay it again or a great (well maybe great) game, that gave you as much as a gameplay trailer or even a demo(Silent Hills) and than took it all away by cancelling the game? What do you think?

Now don't get me wrong, some of those games belong to a franchise and they can be continued or shown anew in a year or two but for now i feel the hurts and surely you do to.

wtf man? so a great game would suddenly become a bad experience because it ends, compared to a game that will never even exist becoming suddenly less bad experience?

i'll play the great game that actually exists, thank you very much. i don't even.... i mean... wtf?