You are right, I don't think either that any investor will be happy, allowing his funds to just go like that after his death without pass it on to his next of kin . As at this stage of your life, you are suppose to have gotten someone which you can really trust to pass your inheritance and if you don't,it means you don't trust yourself either or you are not telling yourself the truth,no matter how distance or close you can be to your family members, there most be someone which you will trust and desire to be your next of kin
If you are an investor, and no one knows your private key, or your private key is not backed up in a place where your family members will be able to see it, after your death, then your bitcoin will definitely be useless after your death, because no one will be able to access it. If you don’t trust anyone in your family, and you think no one is worth sharing your private key with, then it’s just better you write it where people will be able to see it, because it’s just going to be painful that after holding bitcoin for some time, none of your family members will be able to access it after your death.
Just as you said it, there should be someone you are going to trust in your family who should know your private key, and in case you don’t want anyone to know it, then it’s just better to have it written in your will, at least your family will be able to see it after your death and will be able to make use of it, and if they want to continue holding it, it’s fine.
As long as you remember that not your key alone, then it's not your funds I'm okay with that. There was no clause to that saying that states we should trust someone and let them know where we keep our private keys. As an investor your key should be yours alone to know where it is. When it comes to bitcoin investment trust should be something you don't bring to the table. It will break your heart to see that someone you think you trust will move your funds and that's when it will dawn on you that you shouldn't have trusted anyone with your funds.
As a Man if you want to keep inheritance for your family you should also invest physical assets along side your bitcoin. So hat if you die suddenly then those investments will be there for them to inherit and support them. But since nobody knows when he or she will die, it's best to keep your bitcoin wallet to yourself. You will even die faster when someone you trust move your funds, because you trusted the person. Don't trust when it comes to your private keys. It's called private key for a reason.
But if it happens that you die and nobody has access to your bitcoin, don't see your bitcoin as being useless, rather see it as an offering/sacrifices to the bitcoin community.
Because it will reduce the circulating supply of bitcoin, and impact on the price of bitcoin positively. This is another way that bitcoin will appreciates in value.