I wonder why Singlestore has been so unpopular (at least I never hear about it). Quick guess is that HTAP itself isn’t a significant feature requirement, maybe just a cherry on top of other major db features.
ps: I worked at SingleStore. https://www.mooncake.dev/blog/htap-is-dead