Yup. I had students running a machine learning model on a Pi attached to a scooter. The power draw of the computing system was significant, and the performance limitations were too.
The existence of commodity, well-documented, well-supported SBCs offering more computing in less power is exciting.
(Also, using less power means you can put it in more places without worrying about getting rid of the heat, or can go longer before throttling).
The computer was on its own battery to get clean power. And it was using more than 200mA "power", not that mA is a unit of power.
Honestly, it feels like you're trying to prove me wrong about my one case. Power consumption and heat dissipation matter. The pi is rarely the lowest power path one could use to do computing, and it isn't the highest performance, either... but using less power and having more performance makes it suitable for more things (obviously).
The existence of commodity, well-documented, well-supported SBCs offering more computing in less power is exciting.
(Also, using less power means you can put it in more places without worrying about getting rid of the heat, or can go longer before throttling).