The problem lies with people who are technical enough to self-host, but might not be confident enough to fork/make changes. Maybe you could switch services, but there's still just enough friction/soft-lock in to actually migrate.

You are right though, it gives significantly more control to users. It's just realising 100% of the benefits that might be trickier.