How good is Self-Hosted Discourse?

Those different plan levels relate to capacity and support options. When you self host your capacity depends on how much you choose to spend. And you do your own support and customisation. There’s no difference in features.