There are some great last pages in comics that shocked the reader and made you very impatient for the next installment.
Utlimates Vol. 1 issue 2: when you-know-who was discovered in the icy waters
KIngdom Come #3: when a certain someone knocked Supes from the sky.
The old Xmen issue where Wolverine says "Now it’s my turn"
In Grant Morrison’s run on the Xmen when a certain someone takes off his mask.
I mentioned a few exciting ones. Other pages have had a tragic moment but at any rate…