There are multiple providers supporting CNAME-like functionality on the apex that are compatible with Heroku (and other hostname-based endpoints):

* Cloudflare

* DNSMadeEasy

* DNSimple (my company)

* easydns

* PointDNS

I'm certain more will support it as open source name servers add support.