The one that you have not cited is one of the original DESeq publications, which should serve as an absolute truth in this regard: Moderated estimation of fold change and dispersion for RNA-seq data with DESeq2
Also, and I am just quoting the developers from their vignette:
"Genes with very low counts are not likely to see significant differences typically due to high dispersion" [ source: link1 ]
Further, "The trend typically captures high dispersions for low counts, and therefore these genes exhibit higher shrinkage from the rlog" [ source: link2 ]
See also Gordon's answer on Bioconductor: gene dispersion, what does it mean?
We should keep in mind here that each dataset will bring with it certain 'nuances' relating to an innumerable number of factors, including large differences in library size, unknown batch effects, degraded RNA, personnel bias, errors during sequencing, etc.
Methods like DESeq2, EdgeR, and limma/voom have been shown to model RNA-seq data in a way that leaves minimal error when compared to other programs. No program is truly perfect, though, and neither should they be, as they would then only work on the very datasets on which they are trained / developed (similar to some AI / ML algorithms, which one could argue work 'too well').
My point is that, for certain studies, the traditional expectation for the relationship between dispersion and mean count may not hold true for all genes. This is, however, one of the very issues that these programs aim to address.
Kevin