There has been a few moments I think, although its a battle to think of some.
There was a scene in the movie "Apollo 13" that made me want to become an Engineer.
It was when something went wrong in the spacecraft, and a team of engineering guys down on earth got given a whole stack of crap (got dumped on a table), tubes, boxes, random stuff.
They were then told that the air filtering unit on the spacecarft had broken and they had to make a new one out of the random parts that were available to the astronauts, and come up with a set of instructions for the astronauts to assemble it.
If they couldnt do it in a certain timeframe the astronauts would die due to unclean air or something.
I thought it was pretty cool.
Im sure there are some others, but thats all I can think of right now.