IPv6 AAAA vs. CNAME for same domain name
Solution 1:
I copy from DNS for Rocket Scientists:
CNAME RRs cannot have any other RRs with the same name, for example, a TXT - well that was true until DNSSEC came along and in this case RRSIG, NSEC and certain KEY RRs can now occupy the same name.
Therefore what you want to do cannot be done using a CNAME. Use the CNAME to access your homesite via IPv4 and have a myhomesite-v6 AAAA record point to the IPv6 address
If you do not want such a solution, you have to implement a mechanism that updates your DNS zone each time your IP address changes with:
myhomesite IN A IPv4.add.ress
IN AAAA IPv6.add.ress
But that depends on the API (if any) that your DNS provider exports to you. For example if I had root access on the DNS server, I would periodically host -t a example.dyndns.org
and use the output to update the zonefile with the IPv4 address for myhomesite.