Good list. I think Halo--the first at least, I haven't gotten the chance to play the other two--would fall into the Adrenaline rush category when it comes to levels like the Library. Prey was also quite scary, both atmospheric tension and gross-out would probably apply. Going way back, Thief: the Dark Project had some extreme cases of atmospheric tension. You could hear the zombies in the mine, but you couldn't see them until they came within 5 feet of you, and by then it was probably too late to kill them anyway.
TheYokai's comments