In my Model 3, the fan is easily audible at idle and even while driving, when it is set at level 3 (which is usually where it is for "auto", given the mild weather in the SF Bay Area this weekend).
Even when driving at freeway speeds it is still above the ambient sound.
Level 2 is almost...