I recently set up one of these: https://www.lincplustech.com/products/lincstation-n1-network...
and it seems to strike a pretty excellent balance. 4x NVME + 2x 2.5" can get you a lot of storage, but it's still using just a 15W CPU. Build quality is quite good as well.
> E.g. a 4TB Samsung NVMe drive is >2.5 times more expensive than a same capacity NAS-grade HDD
Samsung is far from the only player in the NVMe space. DRAM-less NVMe drives are quite a bit cheaper (~$50/TB), which if you only want 1-2TB is a great option - ie, if you're just looking for a personal dropbox equivalent. Which was exactly my use case for the lincstation - I just wanted to own my own documents, I didn't need to backup blurays or whatever.
In my case I also use the "NAS" for other things like home assistant and plex. So it's not just capacity and power consumption but also CPU. Especially if you are living in a household with photovoltaics a few kW extra don't matter.
SSDs are getting cheaper, but their capacity is still lagging. E.g. a 4TB Samsung NVMe drive is >2.5 times more expensive than a same capacity NAS-grade HDD, and ~4.5 times more expensive per GB than a NAS-grade 18TB HDD at the same price.
What is the point of bean-counting on KWhs if the $ you pay for storage will either burn a hole in your pocket, or leave you with a NAS that will be full in a year and virtually no expandability options?