You're right about low stakes custodial amounts in practice, but I think it's important that the tradeoffs remain understood and that a culture of self-custody still exists amongst bitcoiners in the era of lightning.
Bitcoin moves fast and lightning moves even faster, so I suspect the culture could shift just as quickly to where there becomes a disconnect between how we talk about on-chain bitcoin and L2. I personally wouldn't want that.