Yeah, I hear you. Snow plow is the only commercial one I've heard of that allows self-hosted. It makes sense but you need a new billing model then (e.g. services).
The bigger the data the more self-hosting will make sense for you, but the less for your customers.
I'm not sure if I follow you there. What did you mean by, "The bigger the data the more self-hosting will make sense for you, but the less for your customers"?
I meant that if you're running an analytics company and each client has a huge amount of data, it's less costs for you to host it (better for you as the company owner). If the clients have to self host, then the clients will have to pay for it.
This works for snowplow because they sell services, which only really works for bigger companies who have the resources to self-host and to pay the services fees.
The bigger the data the more self-hosting will make sense for you, but the less for your customers.