Raspberry is great when one learns or needs a typical, embedded platform. I'm using Raspberry to learn about Kernel, drivers, bootloaders, etc., but I wouldn't use it as my local server/home automation computer. For this, I have a second-hand HP T630 that I bought for $46, and works great.
I migrated most of my self-hosted services from multiple rpi (I've been using several of them for years) to a single cheap Intel N100 NUC that I purchased last year: 16GB RAM/512Gb SSD for 156€, and I've been very pleased with it.
Also the place where I acquired it no longer exists, hence why I got stuck with it.
Yes I should have known better, but it is as it is, and we learn from our mistakes.
Two things that actually annoy me is that SD cards are way way slower than other storage options and are very prone to corruption, I've lost not critical data, but data that was still useful to me due to SD cards (even I believe if you purchase them from a known manufacturer). So this implies that you will likely want to have another more reliable storage option to keep critical data backed up (more spending). And the other one is the missing power button. I don't know if that has changed but all the models that I own lack of a power switch button.
Lets be honest many people will have old/spare/extra phone/laptop chargers that they can use to power a Pi. SD cards are cheap, a few dollars.