But then your family rely on you for problems, so if anything happens to you, they potentially lose access to their passwords.

Self-hosting is great, for as long as you're around to provide support.