To agree with Sephex, the Final Fantasy VI one is definitely the most eerie for me as well.

In terms of hilarity, nothing tops 'You've been annihilated' in FFIX. Always made me feel useless as a kid.