I don't think what you're trying to do will be possible without Enterprise, or just using some other public service to get the IPs for you. There was one hosted on Workers (CF was sponsoring it, so presumely Ent and such), I forget the name though
It's worth noting though that it doesn't matter what record you use when it is proxied. You could have an A/AAAA, or a CNAME. Cloudflare responds to DNS Queries with A/AAAA with its own IPs. You can use the API to disable the AAAA Records, but yea like you noticed you cannot disable IPv4 Records, so you just have to rely on clients preferring IPv6 by default (which most should, if they have it, especially browsers), and filtering out IPv4 results from the IPv6 endpoint