I think this is trying to fill a niche that has already been plenty filled. The 64 MB of RAM seems to limit this to applications comparable to Allwinner F1C200

I think this is trying to fill a niche that has already been plenty filled. The 64 MB of RAM seems to limit this to applications comparable to Allwinner F1C200s that came out ages and ages ago, which is an SiP that integrates RAM and can do video processing (h264). It doesn't look like the SOPHGO CV1800B inside this even has proper graphics acceleration. For making proper "intelligent" things, you would want a much more powerful chip. Something like the Rockchip RK3588 is state of the art with 4x A76 + 4x A55. Even at the lower end in terms of cost, NXP's i.MX 8M Nano has 4x A52 at only $15 ish from digikey. Their i.MX 6 line is even more affordable. You can argue that this is a modern version of the extreme low end, but at this point why not also consider more powerful MCU options like STM32H7 or RT1170?