This is important. I dunno about scale, but backups. I started out hosting a chat room on a raspberry pi. It was a fun side project. But then, that became where my friends all hung out. That was the place, so it became important to me. And then the SD card got corrupted. I then moved on to a consumer laptop. It was way more stable, much faster. But if I messed up anything about the installation, I was hosed.
I very highly suggest using Proxmox, like you say, and setting up automatic backups. And occasionally transfer them to a hard drive. It doesn't matter what kind of virtual CPUs or services you install, gedaliyah@lemmy.world, as long as you have a plan for when something you host becomes important to you and you lose it.