For me, it was the old CnC games for their pure cheeseyness.
Next, original UT since that did set the scene for the game - a violent contest.
James Bond - Nightfire - That did send a chill up the spine, it had all the vibes of a Bond movie.
Then, there are all the intros Janes Simulations did, especially for Longbow.
Finally GRID - That pumping remix of Queens of the Stone Age classic No One Knows!!