Instead of paying for multiple services, I am now renting a decently sized VPS on Scaleway, and hosting all my projects on them.

That’s not self hosting. That’s moving your managed services down the stack from PaaS to IsaS.

It’s an unserious take on the impacts as well. No discussion of availability? Backups? Server hardening and general security? Access and authentication models? Sysadmin on aVPS is more than “running a bunch of commands now and then”, and the author ignores that entire workload.