Check out Serve the home’s TinyMiniMicro project: https://youtube.com/playlist?list=PLC53fzn9608B-MT5KvuuHct5MiUDO8IF4&si=1Yx9e7TqLSUlYF3g
This is the route I went. SFF PC with I5 3rd gen, 8GB RAM and about 20 docker Containers running at the moment @ 10% - 15% CPU usage and 3GB memory.
Power consumption is around 15W. A bit more than a Raspi but much more potent and with a easy upgrade path.
So far I have absolutely no rerets. For most things self hosted the cpu is not that important. Even transcoding is no problem with the integrated iGPU.
If you have further questions I am happy to help.
Keep in mind when powering both RaspberryPi from the same powerbrick: some chargers briefly turn the power off and restart the charging when connecting or disconnecting another device. Some do this only between the same type of ports but frequently restarting your RaspberryPi is probably not what you want.