It doesn't really make sense if my family can't enjoy my wealth. Will it be lost or is it good to entrust someone incase I'm no longer there?
In case where the Bitcoin holder dies, no one can move his holdings unless he entrusted the private key to other people he trusted. Unlike you story about bank manager who are able to move a dormant account's asset, no one can access a person's Bitcoin holdings if no one knew about the seed phrase or private key of the said wallet address.
So if you are worry about your family not enjoying the wealth you accumulated in a form of BT @OP, It is better to be prepared and leave hints and clues on how to access your wealth when you are gone, if you do not want them to know about it when you are alive. It is a bit complicated but for your plan to work you need to trust some people. It is the risk that is needed so that Bitcoin wealth will not go to waste and become idle in the system when unexpectedly the owner of the said holdings dies.
Well, you can save your seed phrase so it can be passed after your death. Or pass it before that to your relatives whom you want to get your BTC. I suppose there are also many ways to do this, but I couldn't come up with them, I don't have such plans anyway.
There are, I don't also have plans yet but I have given the idea to my family on what I've written on the piece of paper and why I am taking care of it.
I've told them that when I die, they can take it and do some research but never give it to anybody that will say that they're going to help them.
They should be the one to retrieve and do the importing of it to the wallet that they will be able to find as genuine to access my wallet.
Yeah, the person who should know must be one of the immediate family, it is better to trust people within a family than people outside the family where the possibility of stealing the Bitcoin entrusted to them is highly possible.