The Deep Sea Research Deposit in FFVIII, especially when I got past Bahamut, the research facility part, and into the "deposit". The music really set the mood.

Omega Dungeon in FFX was also great to explore.

Also the Temple of Fiends in FF1 when you go to fight Chaos. Yep.....back in the day.