Based on what I read, you’re right about police/law enforcement/detectives – no military or doctors though. Next would be lawyers, journalists, and writers, followed by farm boys, magician apprentices, and wizards.
Least covered – construction, factory workers, almost any blue collar job. The exception is Hap and Leonard from Joe Lansdale’s books. They’ll do just about anything for a buck. I think they even worked in a chicken plant once.
TV dramas lean toward doctors, lawyers, and cops (and other law enforcement workers) because they allow for a wide range of dramatic situations.
TV comedies have a much wider range, simply because you don’t have to have exciting adventures every week.
Architects are currently fashionable in movies these days. They are white collar and substantial. They’ve probably taken the place of ad executives, which were a mainstay in the 50s and 60s.
Teachers are well represented in movies (if not on TV) as a source for “inspirational” films like Mr. Holland’s Opus, Dangerous Minds, Up the Down Staircase, Stand and Deliver, To Sir with Love, Music of the Heart, etc. Even TV has had things like Boston Public, Room 222 and Welcome Back Kotter.
Movies use the same big professions as TV, as well as adding criminals.
The husband on Medium is an Electrical Engineer, or at least I’m pretty sure he is (Wikipedia says “Engineer”, and he’s always working with circuitry). But three, or even a dozen, examples out of 50 years of television is pretty sparse. Engineers in general are very much disliked by both Hollywood and the general public (and Star Trek does not count; we’re talking about real Engineers).
Well, there was the Emilio Estevez/Charlie Sheen movie “Men at Work” (I loved that when I was a kid) and the television show Roc, in which the main character was a garbageman. I guess Oscar the Grouch doesn’t qualify, though.
Librarians get no love from TV shows and just a little from movies (and the movies featuring librarians suck! Party Girl, I’m looking at you). Even books turn their nose up at featuring librarians as characters unless they’re memoirs written by librarians!
But I’ve got a librarian TV show pilot all plotted out, Hollywood, call me!
I recently read an anthology of library and librarian-related short stories. Granted, the link was tenuous in some cases, but it was there.
I was going to cite Marian the Librarian from the Music Man as a positive portrayal of a librarian, but I guess that’s more played for laughs than anything else.