Grocy is exactly what you asked for.
I never had any (major) problems with Nextcloud yet.
I just have following “conflicts” with it:
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.
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.