To me what most of these portrayals lack is how mundane real scientists are. Completely brilliant in one area and boring, ignorant, and ill-informed in others - just like anyone else. Neil Degrasse Tyson (just one popular science figure today) is as likely to have a valid opinion on politics or history as Joe Montana - but you wouldn't think it.
There's a very real appeal to authority inherent in it, but as long as you can appeal to a scientist - you're alright. What's slightly terrifying to me is the worship of "science" and it being used to justify every Reddit thread, when in reality we're training the public to worship scientism.
Doesn't Big Bang Theory run on the same network as Two Broke Girls after football games? It's popularity might not have much to do with science...