Movies that wasted their premise by making the charecters into idiots

I seem to recall yelling at the screen while watching Silence of the Lambs. Jodie Foster is supposed to be some kind of super special agent, who does every thing exactly right. That is, right up till the end of the movie, where she seems to forget any training she may have had and runs around like an idiot.

Stupid, stupid movie.