Self-hosted things, in my experience, tend to be more reliable. More expensive, too. Worth it. Considerably less churn if done well. That said... reliability/administration is what I do for work. I'm biased.
For instance, skip traversing the internet for in-office deployments/credential use. Also: incentives. PMs or engineers at another company have incentives that don't always align with reliability for yours.
Vaultwarden deserves a mention, happy hoster for years here.
I agree with those points but there's another side to it, of course: The economy of scale of service providers allows reliability, in important ways, that most people can't match by self-hosting.
Absolutely. Things that are very data heavy or require extreme planning, for example.
I'll shell out cash for hosted databases... even though I'm fine with building everything else myself. Topology stuff alone usually makes this worth it.
Virtual machines and snapshots can take you a long way, though :)
What is more reliable (ignoring hindsight), Bitwarden's service or your workplace's systems?