thanks for the honest and thoughtful discussion you are conducting here. Comments tend to be simplistic and it's great to see that you raise the bar by addressing criticism and questions in earnest!
That said, I think the fundamental problem of such tools is unsolvable: Out of all possible analytical designs, they create boring existing results at best, and wrong results (i.e. missing confounders, misunderstanding context ...) as the worst outcome. They also pollute science with harmful findings that lack meaning in the context of a field.
These issues have been well-known for about ten years and are explained excellently e.g in papers such as [1].
There is really one way to guard against bad science today, and that is true pre-registration. And that is something which LLMs fundamentally cannot do.
So while tools such as data-to-paper may be helpful, they can only be so in the context of pre-registered hypotheses where they follow a path pre-defined by humans before collecting data.
[1] http://www.stat.columbia.edu/~gelman/research/unpublished/p_...