I try to keep everything I have running 24/7 as low power as possible. On the other hand, RPis quickly become overloaded for many tasks and so you end up needing a half dozen of them. On top of this there tend to be thermal management issues especially on the newer models.
Fortunately there are a lot of great options for SBCs now that are more powerful than the RPi. For example, I run an NVR for multiple cameras on the ODroid H2 which has a quad-core celeron, dual GbE, and 2x SATA - for only around three times the cost of the rpi 4 B. x86 isn't the best for power consumption but opens up options as far as OS. Due to video encoding rpi-based camera solutions often get close to requiring one rpi per camera!
I replaced my x86-based file server with the Kobol Helios4, an ARM-based SBC with 4x SATA. They've recently announced the Helios64 which will knock it up to 5x SATA with a faster ARM SOC, and comes with a hot-swappable drive enclosure that at least appears to rival the hardware of e.g. QNAP at a far lower price point.
I'd strongly recommend that people look around a bit on e.g. HackerBoards before assuming that an RPi is the best fit for their application. For example, a lot of people are running various 'single-purpose' network applications (e.g. pihole) on RPis when for not much more there are multiple options with multiple GbE ports and faster processors.