Really depends on your use case.

Unraid is wonderful and easy to use. But really has two reasons to use it:Unraid Array fits your file storage strategy. (few writes, mainly reads)You want an EZ way to get into docker and use the unraid appstore.

Other than that, you can probably find everything on Debian or Ubuntu. (I prefer Debian for services)

You can add one more:
Proxmox and then run a Debian VM for docker, for example, and compartmentalize other things you may want to run.

Also, download a mem test utility and run it overnight to test your hardware.

I started out self hosting everything… 20 years ago or so. Then I got swept up in the “cloud” movement and put so many things into the “cloud”.
Today I’m reverting back to how I started, self hosting everything that I can.

Mainly privacy, but also because they keep changing and I don’t want to have to worry about them.
I just didn’t feel like it was ‘my’ data anymore.

Can be safer. Can be worse.

A poorly configured self hosted vaultwarden can be a major security issue.

A properly configured one is arguable safer than hosting with a 3rd party. Lastpass taught me that one.

If you configure it to where it’s not exposed to the web, and only accessed through a VPN, like Tailscale. It can be quite robust.