I would recommend Bazzite or Aurora/ Bluefin. Bluefin is Gnome, and Aurora is KDE.

Both Bazzite and Bluefin are very similar. Bazzite is gaming focused, and the other one is more general purpose, but you can use them interchangeably and also rebase from one to the other.

They are the poster childs of the uBlue project, which uses, modifies and redistributes Fedora Silverblue images.

They both are part of the Fedora Atomic family, which makes them nearly indestructible, convenient and secure.

They focus a lot on containerised workflows, e.g. Distrobox, Flatpak, Homebrew, and, as you mentioned, Nix. They all come pre-installed, and if they don’t work ootb (e.g. Nix), they are just one ujust command away.

I have used both over the past year and I couldn’t be more happy. Give them a try!

Logseq! Right now, you can only self host the database and sync it with Syncthing for example, but the dedicated sync feature is currently in beta and will be self hostable afaik.

Grocy is exactly what you asked for.

Go with Bazzite instead.

The Nvidia drivers come pre-bundled with your install and are baked into the image itself.
The good thing is, they won’t break, and if they should, you can just roll back to yesterday’s image by just rebooting. It’s extremely reliable and lets you just dive into your optimal gaming experience straight away.

Don’t use Manjaro. The dev team is very sketchy and it’s a very unreliable distro. If you really want Arch, for whatever reason, use EndeavourOS. I personally don’t like the rolling release model and find Fedora (Bazzite) just right. If I need something from the AUR, then I use Distrobox.

PopOS is too old for me, and isn’t evolving at all right now. I would skip it until Cosmic is ready.

I never had any (major) problems with Nextcloud yet.

I just have following “conflicts” with it:

• It doesn’t follow the “Do one thing, and do it right”-philosophy. It tries to do everything at once. File upload/ sharing, media management (NC Photos), RSS, mail, calendar, contacts, and much, much more. I mean, it’s damn convenient and works pretty fine, but nothing is great. For example, Immich/ Photoprism is way better than NC for photo management.
• There’s a lot of abandonware, or buggy/ unmaintained apps. For example, my “News”-feed looks completely broken for months now.
• The performance isn’t good. I mean, the “server” (an old thin client) isn’t fast at all, but the loading times and responsiveness is just awful. The file upload also takes ages, even from the same network.
• It feels bloated. I think, if I would be more into selfhosting and had more time, I would search for alternatives and split all the NC features I use into their own services, e.g. one for file upload, one for document management, one for managing my photos, an own RSS client, and more.

But, as I said, the ease of use and amount of features is still great. I don’t want to spend three weekends just troubleshooting my server and searching for/ installing dozens of individial services. And for that, it’s good enough.

If you have a spare laptop/ PC, I insist you to try Nextcloud.

It’s super easy to install, you actually just download the Docker all-in-one container and it runs in less than 10 minutes. You don’t have much to loose.
I’m relatively happy with it.

I mean, to be fair, NC isn’t perfect. It sometimes feels a bit wonky and tries to do everything, while exceeding at nothing.
But it’s damn comfortable to set up and maintain.

It doesn’t perfectly cover your use case, but everything else (individual services, including web server, database, etc.) is less centralised and more complicated to set up.
Since NC AIO is inside a container, all data are too. It’s a relatively straightforward file system afaik.
Backup also is included, but you have to do it manually by default and it stops the services while doing it.

For offloading large files, you might look into 3rd party tools. NC is basically a remote drive you can connect to with most programs that support it.