Oh, boy, where do I begin..?
I will mention a few moments:
1.- The first time that I played Simon's Quest, and I hear the entry screen (you know, that one with the creepy music). The only thing that I want in that moment were to skip that screen!!!
2.- In Aria of Sorrow, the sub part in the Underground Reservoir; the hallway before the encounter with Legion. The absence of music, and the moaning in the background, was simply annoying, almost for me...
3.- The beggining of Dracula's Curse, with Trevor kneel at a great cross, and then the sound and effects of the lightning.
4.- At Super Castlevania IV intro-story, the tombstone being destroyed by the lightning.
And many, many more...