The “long tail” you mention reminds me of the “dead internet” conspiracy theory.

https://www.theatlantic.com/technology/archive/2021/08/dead-...

I wonder if anyone can quantify and keep trends through time of an estimated percentage of auto-generated/bot content, at least for major domains.