self-custody is the best path for any user who really wants to know how bitcoin works. And yes, self-custody is for everyone. Let me explain why is for everyone. The first reason is the most powerful.

1- Exchanges tell you they'll lose and seize your bitcoins if they have to

Look what Kraken CEO Jesse Powell told you:
(...) If you're worried about it, don't keep your funds with any centralized/regulated custodian. We cannot protect you.
Look what Bitfinex's non-financial advice:
Our advice is simple: Bitcoin and crypto should never be left on an exchange or custodial platform for longer than necessary (...)
It's clear, right? No need to explain what they say IMO

2- Non-custodial is a fancy way to say you don't have shit

Please, please understand that the relationship between you and your interactions with the blockchain is through your private keys. If you don't have your private keys, someone else is borrowing you the entrance to your transactions.

3- You don't have your PKs, you're not safe

The OP said:
I increasingly understand that there are people who would feel more secure if they didn't have to manage their Bitcoin themselves
Yes, I get that point. Many people feel safe in the hands of others...until they don't. How many centralized projects need to fuck up in the way to understand that altough you have your own access, you're just using someone else's access, the real user, not you. You're at best an observer, not an user.
And I get the point also here:
there is a concept of deposit insurance for banks, providing a safety net in case financial institutions face issues.
With bitcoin, we don't have these things and we don't need to because...we...have..to...control..our...own..keys.
You don't like to watch your own money? It's ok, then bitcoin is not for you. That's not a bad thing.