Something like the SG2002
Ex: LicheeRV Nano
https://www.cnx-software.com/2024/02/08/licheerv-nano-low-co...
This is sufficient for "automation" hobby projects. You get the full Linux/OS creature comforts without the hassle of doing Arduino or Mircopython.
If you want a full desktop experience (or a project with video output) on a SBC it's probably easiest to go for a Intel SBC
RPi is getting squeezed from top and bottom price brackets
Display out, built in amp, and 1GHz riscv for $10 USD [2]. Incredible.
1. https://wiki.sipeed.com/hardware/en/lichee/RV_Nano/1_intro.h...
and so is a $2 ESPHome..
For actually working with hardware Arduino is much more convenient than whatever abomination you would write in Python.
For anything that needs video output you should use a cheap Android. Anything else is just wasting money.
My conclusion is that although there is some nice hardware out there on paper, the poor circuit designs and atrocious software support mean anything I can get that meets my requirements will be an absolute nightmare; and I'm a software engineer of 1.5-decades with an Electronic Engineering degree, so the bar is high for something to be too-much-effort.
Take the Radxa Zero 3W[0] for example; the WiFi doesn't work properly, GPU acceleration doesn't always work, the OS images are out of date and don't always boot, when it does there are power issues, thermal issues, performance issues. No Debian 12 expected until H2 this year, if lucky; Android OS images are Android 9 (we're on what Android 14-15 now?).