This alternately harrowing and beautiful video was taken by a pinhole camera on the side of one of the boosters of the STS-124 launch, after they separated and fell back to earth. It's literally like falling out of the sky.
[There was a video here]
[YouTube]