Can't believe I didn't immediately think of this one (and surprised it hasn't been posted), total classic:
I remembered the intro to Silent Hill 3 being way better. Watching it again the song is still great, but as a whole it comes off kinda cheesy. Like a basic music video for a tune on a movie soundtrack that just plays random scenes and spoils the best scenes the whole movie.