The ending of a movie like "The Mist" depressed me, a seasoned soldier, for a whole day. Stay away from it!
By the way, "The Mist" has, shall we say, a "non-American" ending :)
In general, I agree with Wesker. Often, the death of one of the main positive heroes leaves a very strong impression, especially if it happens extremely unexpectedly.