[Mnemosyne]

Like any subcreator, I'd have to go with the scene from "Leaf by Niggle" when the protagonist finds his own life's work perfected and in the flesh. Gives me goosebumps every time.

Bilbo's Last Song would come in as a close second, though.