Is an Intel N100 or N150 a better value than a Raspberry Pi?

Yes. You can get dirt cheap mini-pcs / NUC like devices on ebay for next to nothing and they aren't too crazy on the power front.

The biggest problem for the Raspberry PI platform if you are using it as a home server or like a lite desktop is the lack of proper storage.

However I do like the pi for things where you set them up and forget about it. I run a pi-hole on an old Pi 2. However that could be run as a docker container on a small home server / NAS.

You cannot just compare raspberry pi specifically with all the slew of the random no name / ephemeral mini-pc builds, they're not the same.

I was trying to find something deemed reliable for myself (I need two: one to replace kodi, one as the home storage) and I just don't know. Some have good prices and terrifyingly bad reviews, some look decent but in-depth reviews show significant design shortcomings (eg very bad air circulation inside, 2.5G ports but one chip for this and dosk, for example.