I think there's a point where self-host all the things breaks down. Specifically when there's either a knowledge gap or time availability issue that is so significant that overcoming it would cause issues in other parts of life, and this is different for different people. But if you can, and there's not a ton of friction that you're unable to deal with, self-hosting is the way to go.