I agree with FO about Metroid 2. Most atmospheric? Probably Zelda 64. I'm not really sure.

"Prepare for trouble! Make it double!" - James FP