Where are these tiny low-power RPis that idle at 1W ? Are you measuring at the wall (i.e. with the power adapter inefficiencies?)
The entire point of the article is that at least the non-micro RPis are not "low-power" at all (something that agrees with my observations). The article is quoting around 3.5W for the RPi5. I was also getting a similar reading for my older RPi4 after months of fine-tuning, while _out of the box_ an N4000 miniPC had 1.8W consumption at idle. RPi may be cheap, but not much else.