Everything a human can make, another human can break (or hack) is something I try to keep in mind. Meaning nothing is 100% safe and if you want, you can make anything sound unsafe!
This means I try to be mindful about what I do and place on the internet. For example I never go all-in with a new note-taking app (sorry Anytype haha ) and just try it with general not important data (like a movie database or copy some existing notes from my main app).
I also try to keep backups and have files on synced on multiple devices (no sync is not a backup). Managing risk if anything goes wrong, you could lose your account by many ways (losing pasword, getting hacked, being deleted by the company or yourself, losing your device, etc).
On top of this, I try to see things in perspective.
While the cloud of big companies like Google or Microsoft have disadvantages like being a big target, they can potential read your data/notes, you could get deleted while doing nothing wrong, etc… they also have advantages like 24/7 security team, solid apps, probably won’t just go bankrupt and being in the news if something does go wrong (meaning you know it pretty fast).
Same with the cloud of small/new companies like Anytype, Upnote or Capacity. They have disadvantages like asmall team, have to prove their staying power, might go in a totally different direction or stop development, unclear privacy documentation, etc… but again also have advantages like being involved in the development as a user, seeing the progres that is being made first hand (giving a lot of faith in the product, thanks you for that Anytype ) being a strong niche app that focus on privacy or offline first, not a large target for hacks, etc.
And we can do the same about self hosting. It has disadvantages like doing everything yourself, including making backups, managing security, making errors or deleting your notes on accident, being hacked and not even know it, etc… and like the above have advantages like being a small target for hackers, privacy very high, being in control, etc.
So to recap, it is all about managing risk and seeing things in perspective in my honest opinion and never just trust a single source like that guy or this guy who’s post you just red.