I'm not sure about everything that S300 CRE uses, but I can tell you from the handful of companies that I'm familiar with that use it, there are several things that are quite useful from the automation side of things:

The ODBC drivers are super useful, we use these to connect into custom programs that interface with our web applications.  So our web applications are able to send back and forth any information needed.

It is also great for any power users, as they can be connected to with MS Excel and they can run custom queries and reports.

The replicator is a full fledged SQL server, so with all the services there, it is basically able to do anything you need.  

MyAssistant an automated reporting module, is super useful for anyone who doesn't like running the same report every week and emailing it out.  It also allows for approval workflows, but most of our companies just use it for automated reporting.  

We've also hooked into programs that allow it to email out paystubs for all of the direct deposit employees.  - We integrate with Piracle/create-a-check and with that software and the hooks there, it makes it so blank check stock can be used.

We haven't been perfectly happy with the replicator yet.  It seems to stop working fairly regularly and needs to be restarted.  But with year end, and everything else going on, I haven't yet been able to spend the time to complete solve the issues there.

They also use crystal reports for advanced reporting.  And since Crystal Reports can connect to the SQL server, they use the SQL replicator to provide much faster crystal reports then it normally is able to generate.

I'm sure there is a lot more, but if you have questions feel free to reach out.