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.
I printed a few of these: https://www.thingiverse.com/thing:4820432 And bought a few of these: https://a.aliexpress.com/_ExBOJ6F Then store everything in vacuum bags after print. Works great for me!