How do you host nextcloud? At home or on a vps?
On a VPS. Later down the road I intend to build my own home server, but that will take some time and money. A VPS is not ideal, but that's leagues above trusting Google and the likes, and so far it has been working well enough for me.
Did you have any self hosting experience before doing that?
None at all.
Do you know Logseq? It’s an OpenSource/FOSS alternative to obsidian
I did try it, and it's a cool project, but not as good as Obsidian, imho.
I used this guide: https://github.com/nextcloud/all-in-one/blob/main/reverse-proxy.md
I also had the help of a webdev friend of mine, that taught me the basics of how to setup and use Docker.
I hired my VPS for around $200 a year (after comverting from Brazilian Reais to American Dollars). It gives me a VPS with 2 vcores, 2GB RAM and 40 GB SSD. There are many VPS providers that can offer you somthing with similar specs and and prices, like Hostinger, AWS and the likes. (Depending on where you live, you may actually find much better prices)