The N100 is definitely powerful enough run a ZFS RAID array. Depending on what all you'd like to run, it might be enough. Check it out with cpubenchmark's compare feature!
I used a Celeron G4900 (also has an iGPU) as a plex server for years, and it's half as powerful as an N100. The celeron is a fairly slow processor, but for plex it was enough since the iGPU did the heavy lifting.
I'd highly recommend joining the serverbuilds dot net discord. They also have a forum with pre-specced NAS build configurations, complete with pricing. People there are very helpful and will give realistic advice.
I think Jellyfin beats Plex on 4k transcoding (tonemapping?) with the iGPU, but fwiw I do not transcode 4k and add subtitles to them just fine. I use an nvidia shield, which direct plays 4k content with the added subtitles. Hearing about transcoding 4k content just to add subtitles is news to me.
I have a bunch of SFF computers (Dell 7060, HP 600 G4, etc) with i7-8700 or similar CPUs. They all idle around 12 watts.
Most of the mini pcs use the T version of the processors, which are usually 35w TDP.
Power usage will definitely be higher than an N100 (65W TDP vs 6W), but they're a lot more versatile since you're getting more than double the performance, 2-3x the threads, and an iGPU that can do things like transcoding for plex and accelerate ML models for Frigate/Scrypted.