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"?
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.
I've been looking at Snowplow and it seems really cool.