I hit the limit of my Raspberry Pi 4. It would periodically crash itself by overheating (Heatsink was hot to the touch) I now use a NUC. It runs excellently, and handles my home automation setup fine. Unless I start doing something extreme, I can see myself overloading it.
One of the less mentioned things with self hosting is running costs. A Pi is extremely cheap to run. A NUC is a bit more, but still well below a full blown PC. Servers can actually pull a significant load, even when idle.