Part of me wants to say Kefka's Tower or Ultimecia's Time Castle because they were unique from a gameplay standpoint but the Lunar Core is the dungeon that still gives me goosebumps when I got through it and it was visually impressive for its time.