After spending ages setting up my first Umbraco Cloud site, adding the www.motorsportsnt.com.au hostname has proven to be frustrating.
I get an ERR_SSL_VERSION_OR_CIPHER_MISMATCH error now that the site is live, and no amount of fiddling with DNS settings seems to make any difference
There were existing CAA records on the domain, which I have removed. Initially TLS in cloud was set to 1.3 so I changed to 1.2 just in case and no difference.
If a domain has restrictive CAA records, certificate issuance can fail. Removing them usually works, but another option is explicitly allowing Google Trust Services:
example.com. IN CAA 0 issue "pki.goog"
Since you mentioned you already removed the CAA records, it might just take some time for DNS changes to propagate and for the certificate to be issued by Umbraco Cloud.
You can check whether your domain still has any CAA records here: https://caatest.co.uk/