Well, I'm not entirely sure how sound the science is in Knowing, but that movie pissed me off with its portrayal of scientists. Apparently an MIT physics class teaches rudimentary high school physics. Also, scientists are apparently not people who believe in testing the evidence, or sharing important (and matter-of-life-or-death) findings with their colleagues, but are instead Priests of the Church of Science, whose dogmatic laws of nature shall not be questioned! Who wrote the script, Kirk Cameron?
Ironically, one the best recent portrayals of a scientist in a movie was Snakes on a Plane. The herpetologist is a bit geeky (but what PhD isn't?), but as soon as he's apprised of the situation, he takes complete control, and tells the Feds exactly what they need and what they need to do, giving them important information on the case.