Truth be told, you can't really trust anyone at all, even if they are your family or your closest friend, you can never really know what goes inside their minds, probably that's the only time that you can trust someone, is if you can read their minds but trust is a big deal but in my opinion, if you absolutely need to give it to someone in case something happens to you and you don't really want your savings of bitcoin go to waste, always stick with family, you can't really leave behind your legacy with your friend no matter how close you are to them, probably the only time that the latter would matter is if you've got a toxic and vile family relations that has gave you nothing but trauma, that's the only time that I think closest friends would matter when leaving something valuable is being talked about.
If you are still undecided, probably for the best if you go with a lawyer and have them keep your seed phrase and write it in your will whomever will receive them, you can always rewrite it if you feel like the current heirs would be unworthy. And on that note, also worth noting that out of all the options, lawyers are probably the one person that can trust when it comes to your seed phrase as they're binded by client confidentiality and I don't think any self-respecting lawyer will jeopardize their career that they've created for themselves from scratch just to steal your seed phrase for themselves.