You already know how to work with it, so here’s my links to scripts for copying the formula down when ARRAYFORMULA doesn’t work.
Hope it helps.