The super badass guy. Just seems so lame.

The worst is when a show or movie establishes that X can't be done, because Y. Then in a later scene X is done without addressing anything about Y. It's actually pretty common, especially when run time needs to be padded with a side quest.

For that matter, when someone gets shot center mass and they collapse like Cypher just pulled them from the matrix

Fridging, it's just plain lazy.