I fell asleep during Superman Returns, partly because I got dragged there immediately after returning from a 9 hour plane flight, partly because I'd seen the plot in the first five minutes.
The only time since being a child that I can remember falling asleep in public. That only ever happens when I'm that tired though, normally I'm wide awake because I'm not trusting enough of people around me.