I’ll chime in here to confirm that everything that Stephen posted is correct.
On our hosted sites you have full access to the Discourse API, but you do not have SSH access to the server. Custom plugins cannot be installed on our Standard or Business sites, but plugins that you develop can be installed on Enterprise sites after the plugin has been vetted by our team. To see the plugins that are pre-installed on each of our plans, have a look at Plugin directory | Discourse - Civilized Discussion.
Custom themes and theme components can be installed on any of our plans.
The easiest way to get a sense of how our hosting works is to sign up free trial on either the Standard or Business plan from here: Discourse pricing | Discourse - Civilized Discussion. We never start automatically billing for trial sites, so this is a risk free way of checking out both Discourse and our hosting service.