For me it's probably the entirety of the well-known (and somewhat unknown) parts of Yume Nikki.
However, Eversion is definitely a top contender simply because it starts out so nice and child-friendly, but ends up like this
There's also this moment in Super Mario Galaxy 2
which up-close looks like this
