Great videogames often have ambiguous endings -- joy mixed with sorrow, to paraphrase Kojima.
Final Fantasy 12: joy at vanquishing the Empire and freeing a people, sorrow for the lives lost in the Empire's wars and the unspeakable crime of Nabudis
MGS3: speaks for itself.
Half Life: wisely done, Mr. Freeman!