I don’t understand all of the concern about custodial vs non-custodial lightning

Lightning (custodial or non-custodial) should always be for small amounts and day to day transactions. On-chain for larger transactions and longer term savings.

Onchain Multi-sig as a deep saving vault (multi-year hold), onchain single-sig as a regular checking/savings account and lightning as the wallet/cash you keep in your pocket