My car came with a security bolt adapter in the glove box that made a sound like that.
I've checked the drivetrain, quiet as a church mouse.Put it in L, lightly go forward a little, let off pedal and do that like you are in stop/go traffic.
If you can her it like that, kinda of a tap noise, then it's your Transmission.
Had mine replaced after 2 years of them saying they hear it, then Nope no hear it. Because they were tired of not making money on a warranty work order