I can’t get name resolution to work for any sub.sub.example.com domains with creating the sub.sub record in the management UI. All other domain records work and resolve correctly.
Are you sure it is DNS resolution and not an SSL issue? Note that Cloudflare’s Universal SSL only issues certificates to cover example.com and *.example.com so to use second-level subdomains you need to use the Advanced Certificate.