For what it is worth, I’ve had a lot of jobs and have been a student for a long time… I don’t know a single professor who likes to be addressed as “Dear Professor” for anything other than the first email.
I’ve also been lucky to work in really non-pretentious areas though.
(Formal communication is different from regular emails, IMO).