Whims of Fate or Ark for sure, unless we're counting the last "dungeon". I know it's not really a dungeon theme but Life Will Change playing on loop during the final heist of sorts is amazing and one of the most energizing moments of the game for me.