Pi has its own niche where it's great... and "Desktop" is not it.
The moment you feel you don't care about power consumption, but you do need NVMe SSD and 8GB of RAM, it's time to look for something else.. NUCs are a great example and if you buy them used on eBay they can be even cheaper.