Started with one RPi 3, ended up with 5 in a case that needed ventilation and a switch. It looks cute, but... The only one working to my pleasing is PiHole. Nextcloud is slow as hell (you are bound to external HDDs over USB and that sucks). 3 use normal HDMI ports, 2 mini HDMI. When shit hits the fan and SSH doesn't work for some reason, I have to plug in a monitor and keyboard.
Oh, and one SD card went poof due to not noticing it had no free space left and still writing logs on it for 2 weeks. SD cards are unreliable in general.
I regret not using VMs on a more beefy mini PC that I could have upgraded to my pleasing, benefit from SATA, and would have been easier to maintain.
So I would recommand RPis if you actually need and use the IO ports. Otherwise, you will soon learn they get overburdened. For general self hosting, myself would have gone the ProxMox route (which has a free tier and that's what I have experience with).