And the PI has many advantages. Power supply dies? I can order a new one in literally seconds. And meanwhile I wait for it to arrive I can use a spare notebook charger or whatever. Etc.
The shortage sucked, but it is solved now.
Last image I created I tucked in a Raspberry Pi 1, and it worked just fine. The versatility is unmatched. Equally I can test an image at my home and then let someone install it on the other side of the globe.
The point of a Pi for me is more that you can have it where you need it. Attached to your TV or whatever.
For a home server I would recommend something beefier, an old desktop will be superior to any mini-pc and the Pi. But probably bulkier and more power hungry.
A Pi5 with nvme does work and be a decent home server for tinkering though. From my perspective the niche for the mini-PC is pretty much nonexistent.
But I don't think maximum utility is the goal though, it is a hobby. Do what you enjoy! Tinkering with low power PCs might be enough of a reason alone.
But these comparisons to the Pi doesn't make much sense to me.