That would drive me NUTS! Out of place noises in the car really get to me. Once I hear them I cannot focus on anything else.
My escape has made various sounds that I have had corrected - ticking from the cargo door latch, clicking from the cargo door's window latch. I also had the same noise you describe in #2 of your original post. I had all of them fixed but it took three tries to get #2 fixed because nobody could figure out what it was. Here is the thread I showed them that led to it being corrected:
I wish you luck with the sound in your recording. That's an odd one. I just put this out there - is it possibly something loose on the roof rack? maybe have someone drive while you stand up with your head through the sun roof. See if you can detect it from outside.