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

Are the two boards even in the same category or class?

I use RPi for little hobby projects

- RPi Pico for being the payload that flies around the world in a PicoBalloon

- Decoding NOAA weather imagery and storing it in my Google Drive

- Full time AIS message decoder and tracker

- Full time ADS-B and MLAT receiver

- Runs my RetroPie setup

- Runs my OctoPrint setup

I wouldn’t replace much of that with an Intel NUC style computer

Except for the Pico (which is very different from the full RPi), you could do all that with a mini-PC.

There are certainly usecases, especially using the RPi's low-level IO, where that's not possible, but as you yourself have shown, people do often get into situations where they are competitors.