I've got a rattle/wind noise issue on passenger side only which occurs when I'm > 40mph or so.
Mobile service came and replaced the plastic triangle near the side view mirror which i thought was the culprit but it wasn't. Old part didn't have any double faced tape. New one did. Seems like the sound is even louder now. On another thread (w/video) someone mentioned it might be the plastic piece attached to the frunk hinges. Instead of double-face taping it to the hinge I just took it off. That wasn't the source either.
Not sure where else the noise can be coming from. My guess its either the plastic triangle or perhaps the b-pillar. It doesn't look flush with the passenger window. Maybe high speed air flow is causing it to vibrate and rattle.
I can also hear the motor when accelerating. I actually like the sound. Reminds me of Disneyland's California Screaming ride.
If you do a search on "wind noise FLIR" you will see that some enterprising folks have taken to using forward looking infrared cameras to find the source of these problems. One Model 3 owner proved to Tesla service that there was a huge hole in the windshield sealing agent that was causing his noise problem after detecting it with infrared... he plugged it with some silly putty to temporarily stop the problem.
You could also look at the door seal installation on that side. The door seal has an outer channel that's larger/thicker and a small inner channel that needs to be tucked completely into the vehicle body. If either of those seals are loose it can create wind noise too.