If all you want is a home media NAS with no frills like ZFS, redundancy, etc., the RPI 5 is the lower power option, thus better IMO. Of course here, a RPI 4 is probably even better.
I have a RPI 4 I've been running for ~4 years as a GIT mirror and it has been rock solid. Prior to that I used a RPI 3 and rsync to backup a GIT, which was also solid. That said, I don't yet own a N100 but, I have 3 different small Chinese N100 boxes in the mail from Ali :-). Which ever of the 3 I like best will become my new default Klipper machine (3D printer firmware) and 1 of these N100's should comfortably replace 2 RPI's, this will be very nice for me.
The increasing flood of these N100 boards has put the RPI 5 into a position where the RPI 5 has become completely irrelevant for me, for when would I buy a RPI 5 instead of a N100 or a ESP32/Pico W/etc.?