It seems underpowered expensive and not very reliable.
Nowadays, the Pi seems to be used more as a small computer, with more power, more memory, more storage, and a higher price. I've never owned one, but it looks like it's a completely different product with a different target audience now than when it started.
RPi lost the price advantage, when Intel dropped the prices on the low power CPUs. Even when the RPi4 came out the embedded / N100 type CPUs (yeah I know those did not exist then but the equivalent) were more then the entire RPi itself. Now Intel is pushing the board + CPU (no ram) should be at the $50 or so price point. So getting the mini PCs out the door now for $175 is not even that hard.
The Zeros and other ones are a different story but the last run of the 4's and now with the 5's RPi has gotten more expensive.
HOWEVER, the RPi can be more of a tinker project. There are a lot of cases, add on boards, and other things that you can use it for. The mini PCs are.....mini PCs if you can't plug it into a USB port you can't add it.
In the end it really is going to depend on what you want to do with it.
The new mini / NUC vs used micro PCs that Phil uses can probably be discussed forever. It really comes down to what *you* like.
-Dave