Hi @Jay Parnau ,
The same thing happened to me.
You need to update the query inside the module.
- Open the "DBCleanerOnSteroids" module
- Find the "GetTables" query inside the "GetTableStorageStats" actions
- Add the collation statement "COLLATE SQL_Latin1_General_CP1_CI_AI" in the correct place.

As you can see on the image above, this LEFT JOIN is trying to relate two different databases: "sys" and the "OS database". And it seems they have different collations. It happens.
Remember, this solution will not help in all cases, and it is not advisable to use this everywhere you find this error.
The COLLATE statement is ANSI and also be supported by Oracle and SQL Server. But the collation name should match with the error message to work properly.
Please, check the SQL Server documentation: https://docs.microsoft.com/en-us/sql/t-sql/statements/collation-precedence-transact-sql?view=sql-server-ver15