This is a common fallacy. That is not actually the tradeoff you are making, in fact you are taking a hit to the mean value, and also greatly increasing the chances of being on the wrong side of the average[1]. Dollar cost averaging increases variance and decreases the expected return in proportion to your averaging period. You earn less and have a much lower floor for almost no increase in the ceiling.
There are nice visualizations here: https://ofdollarsanddata.com/lump-sum-investing/
[1] at least according to history. Who knows what the future holds.
Maybe you could compare and choose an option with less variability or standard deviation even though the mean return is worse. But these studies don’t compare the size of average losses and gains. I expect that the variance is also better for lump sum.