It's only possible to connect a subdomain like blog.my-awesome-site.com to our blog.

Technically, www is a subdomain. So you can add this like you normally would, as described here. You just need to redirect my-awesome-site.com to www.my-awesome-site.com. The result is clean and without any drawbacks.