Always self-host anything you can (reasonably).
In this case, don't self-host a password vault. Use a locally encrypted password storage app, and keep it in a self-hosted storage solution (which should also be encrypted).
People want to put too much shit online, opens you wide up for attempted hacking (especially if you use what everyone else uses).