I’m sure I would be just as useless as an LLM in the “niche stack” examples that you cited.

Why do you think that is actually a good argument against? Most “business” problems have already been solved in some way and the times I had to write really novel code in my career have been very very few.

Also sure LLMs haven’t solved cancer or unequality in the few years they exist - but humans also failed here in the last couple thousand