This calculation makes me curious, as I know very little about computer engineering/hardware but want to learn: what is the current-most energy-efficient general CPU architecture/core in performance-per-watt? Some high-speed ARM? A Y-series x86?
This number seems quite optimistic to me (I've found it on wikipedia). It just happens I was coding for fun in assembly language on Apple II some weeks ago and the minimum opcode length is two cpu cycles, so I'd say at best we're at 0.5 mips (the apple is 1 Mhz). And for anything useful it'd be closer to 0.25 mips).
Ultra-low-power 8-bit microcontrollers? 1 MIPS @ 1 W is possible on a AVR I believe, but still much less efficient than a modern CPU. Economic-of-scale at work, you can't compete with greater integration.
Generally you don't ship FPGAs in consumer devices you plan to sell in high quantities, as they're very expensive in addition to not being very efficient. Small FPGAs or CPLDs can be used for low-volume devices to avoid the huge non-recoupable expenses of an ASIC spin -- because of the specific requirements of the application.
They're almost exclusively used for prototyping ASICs.
Apple II: 0.43 Mips @ 17W
RPi3B: 1822 Mips @ 1.2W
So I wonder if there is a solution as energy efficient as modern hardware, but as slow as 8 bit machines.