Practical use of row_delimiter with TEXTSPLIT

Let me be clear, I am not asking HOW to use the row_delimiter part of the TEXTSPLIT argument, I am asking WHY. Any use case I have come up with so far would be better addressed by Power Query. Even if there is a reasonable example, it still seems like it would have to be looped using VBA. Is material out there on what the developers had in mind for using it? If anyone knows, please share or share any example you have. 

(I'm in pretty much the same place with the ignore_empty and pad_with parts of the argument as well.)

Thanks!