I think Observe and Report is a pretty bad movie but this scene with Collette Wolfe is amazing. Her acting is heartbreaking.
The plane rescue sequence in Superman Returns is classic Superman with modern VFX. Too bad the rest of the movie didn’t work as well.
What are other examples of great scenes in not great movies?