I haven't noticed anything weird when using CloudDrives with storage spaces. But to be honest I haven't really used it that much. It seems its just that Storage Spaces can't properly identify what type of drive the drives created by CloudDrive is and that prevents it from creating storage tiers on the drives.
Also wanted to clarify as the ticket says "Can't add a CloudDrive Disk to a Storage Spaces array." This is incorrect. I can add the drives just fine and they work. Its only storage tiers that don't work. See: https://blogs.technet.microsoft.com/askpfeplat/2013/10/20/storage-spaces-how-to-configure-storage-tiers-with-windows-server-2012-r2/ (Article about Server 2012, I'm using 2018 but the concept is the same)
I understand that this is a niche usage and therefore not a priority. Will keep an eye on the ticket and hope for an update some time in the future.