Good post. I haven't used Carto, Every Door, nor StreetComplete, but some of the consistency and non-ESRI-ness that OP is seeking seems to me to be present in Regrid fka Landgrid:

https://regrid.com/why-regrid