Stormblood [4.0]: Post may contain potential spoilers.
Mason’s Fall
This appears to be the largest waterfall that I know of so far and no the waterfalls in the sea of clouds don’t count. I forgot to check, but this might be able to challenge some of the tallest zones from the previous expansion. Although, it won’t beat Azys Lla.