Depends on which model will be more beneficial to your customers and also be profitable to you at the same time. You can learn from companies like PostHog that stopped offering paid self hosted managed solution. Either you use their Open Core version yourself OR you pay for their cloud hosting. This article will hopefully help:

https://posthog.com/blog/sunsetting-helm-support-posthog