Honestly the major sticking point of Pis for me is that their microSD cards are wholly unsuitable for anything that may lose power or requires long term reliability. Most equivalent manufacturers such as the one above ship with eMMC, which won't get corrupted by sudden power cycles.
If you're using a Pi at home and need greater reliability, a quality portable SSD [0] will get you pretty far. The systems I run that way have always been quite fast and reliable.
(don't use an SATA to USB adapter if you can help it, they tend to be flaky and it's a very strange place in a home system to try and save a few bucks, even though a lot of people do it)
[0] https://www.samsung.com/us/computing/memory-storage/portable...
I was skeptical when I first tried them. I figured it would be too tempting a target for counterfeiters-- source the cheapest SDs available, screen the sandisk logo on them and sell on amazon for $12/each. Fingers crossed -- so far, so good.
My real point is once you are out of that "it's a cheap board I can get for $30" type territory it makes more sense to get something substantial.