The later hardware revisions (such as 1.5) of the Raspberry Pi 4B, even with 8GB of memory, can idle at ~1.33W on WiFi with everything unnecessary disabled -- 2GB versions are close to 1.1W. The 8GB version on power-hungry Ethernet (at 100Mbps) can actually be under 1.45W, compared to 1.68W for 1Gbps. PoE is nice, but the hat adds a lot of power -- though it's possible with an 8GB to squeak under 2W via PoE at 1Gbps, though only just barely (~1.98W).
-- -----
For those who go, "but I need real power"... you can have an 8-core Ryzen 7 PRO 5750GE (with GPU cores for transcoding), 64GB of memory, multi-TB NVMe SSD, and two NICs (one 1GbE and one 2.5GbE) plus WiFi and Bluetooth idle at under 9W. No, it's not 4W, but to say it can do nearly anything you can imagine is an understatement. You're at the same CPU performance of an i5-12600, with tons of memory for VMs galore, in a system that has the same idle power as a cable modem.
I believe Apple rates the newest Mac Mini with an M2 Pro, 32GB memory and 2TB SSD at just 7W idle. Again, given it's capability, that's pretty wild for 7W.