I think the problem with your bullet points is that something like an ESP32 beats a Pi at all of these criteria (as well as on cost), and can be wired/wirelessly tethered to whatever PC you have handy if you actually need a bunch of compute.

With the exception of the Zero, Pi has always been playing in the realm of "this is a real computer, except cheaper". And that's a pretty crowded space these days.