the shinra mansion had that ambience, during the flashback when sh#@$# starts getting crazy, and even when you go back.

Learning about Seymour's past in X was very creepy, especially the memory sphere with Jyscal.

The night of the parade in FFVIII was a little bit like that, very atmospheric.

The opening section at nalbina fortress in FFXII is very dramatic, almost has an eery feeling to it, especially what he sees when Rex says "Your Majesty..."

The first 6 games + 9 were all kinda campy/corny/cutesy.