Selfhosted

To give you an idea of what you'll experience in your self-hosting journey: adding services is the easy part, maintaining a system in production over many years is the hard part. And the self hosting solutions you mean are quite bad at that. Eventually I ditched even Proxmox because its updates are cumbersome and you never know wheter you'll end up with a working system after the upgrade.

Ultimately, you want to avoid any complex transitions in your system altogether. Decouple everything, make everything disposable, especially your OS. The ootb-selfhosting-solutions are the antithesis of that: lots of hidden magic behind colorful buttons, which makes it immensely hard to get a working setup the second something goes wrong. And that will inevitably happen with time passing.

It's easy to get going with something like that, But it's much harder to migrate to something else. Additionally yunohost doesn't have Support for some kind of containerisation, which I find very useful, when I just want to try some application and completely remove it afterwards (without praying that my single database doesn't break). I mostly use portainer to manage my Selfhosted applications, and it would be quite easy to switch to docker compose or another container orchestration platform if portainer does something funky