Possibly not directly related to Amnesia the game, but I still hold up Planescape: Torment as a great example of using an amnesiac protagonist to tell some pretty incredible stories. I suppose Planescape: Torment is pretty old now, but I do think that there's still potential to use the idea well.