Every time Kain has an inner monologue in Blood Omen: Legacy Of Kain.
The last two boss fights in God Of War: Ghost Of Sparta.
The boss of the Palace of Winds in The Legend Of Zelda: The Minish Cap.
Finding this thing in Bloodborne scared the ever-loving bejeezus out of me! A wonderful moment.