What are the times in which it is useful?
If those are referenced in the linked article, I'll be honest I didn't read it. That website succeeds whole handedly in its job of being too annoying to read.
To be honest I don't know of any, I just didn't want to be outright dismissive of it. If you just use it for a header to have some kind of small animation that grabs the reader's attention I guess it's fine. Just don't use it for the main text body.
im sure theres a class of people who gauge their willingness to read based on the length of scroll.
Some news articles work well with a long scroll. Usually to progress through the "time" of the article. But yeah most of the time it's just annoying.