Mine does it too. I've heard others say this as well.
Forget who explained it, but they stated it was something in the transmission that resonates in the bellhousing. It changes depending on the modes and is loudest in Sport. Stated this was normal.
That's a 3rd hand explanation i know, but was something I noticed on my car when new and was curious about as well.