Yes and no.
My spouse can easily access anything family related - pictures, documents, passwords (keepass) from their computer. The NAS and the Colo Server both present as shared drives on the network and they use it almost every day.
The USB drive is plug and play and has copies of anything important.
However, all my git repos, websites, tech projects etc will probably not survive my passing. I don't really care about that.
They will still be backed up and accessible on the NAS, so if someone in my family (I have a few technically adept people in the family) wanted to check it out, my spouse would be able to give them access. Honestly, I don't think anyone would care, but who knows.
All passwords and access details are in KeePass and my spouse uses that everyday so knows how to use it,
My colo server is paid a year in advance every year, so it would chug along for a few months before the provider shut it down and shipped it back to my house (again, my spouse knows how to get it shipped back).
All in all, I think my family would be able to access anything truly valuable without too much trouble, and who cares about the other stuff anyway.