The reason why social media and similar websites now have infinite scroll is because the next page button provided you with a circuit breaker to stop and reconsider if you actually wanted to continue or if you were just mindlessly scrolling.
So if you have a genuine intention not to use certain websites at particular times (e.g. work time), then having any kind of forced interruption can be useful for changing that behaviour.
If you're looking to create genuine change, then making those websites load slowly is even more effective than going cold turkey (because it minimises the dopamingeric effects.)
The friction makes me want to disable the measure before it makes me want to stop the activity. And unlike paging in forums, I can disable it. That’s why these measures never work for me.
Having tried that many times, it just doesn't work for me
Maybe others have better luck