Some helmets have sweat channels molded into the brows to direct sweat from running straight down the face. On really sweaty rides the sweat droplets can feel like rain spattering my face, but it's still less uncomfortable than my old helmet.
Check out the Bell Formula MIPS and similar Bells, and some POC helmets. My Omne Air Spin also has sweat channels and it works well. Much better than my older Bell, and better than my aero helmet that has only two sweat channels and poor ventilation.
I also wear bandannas most rides but they don't get quite as drenched and often are nearly dry when I get home, although there's obvious sweat marks where the perspiration accumulated and dried quickly from the helmet vents.