I liked it in ASM #311, when a wall transformed into a giant rock monster. Spider-Man fought it, but it ended up killing a civilian. For pretty much the rest of the comic, Peter was beating himself up about not being able to save the man, but when he finds out it was all an illusion made by Mysterio, well, you know what happens.
That'd be great in a movie, in my opinion.