Since we lost Columbia in re-entry, NASA has installed more cameras on the solid rocket boosters as part of their new safety protocols. Here's a video from the last launch:
http://www.nasa.gov/multimedia/nasatv/on_demand_video.html?param=http://mfile.akamai.com/18566/wmv/etouchsyst2.download.akamai.com/18355/wm.nasa-global/ksc/ksc_112608_sts126_srbcam.asx&_id=177889&_title=Amazing%20Views&_tnimage=293895main_ksc_112608_sts126_srbcam-t.gif
two words im-----pressive
very cool stuff, my dad worked on the shuttle in the early 80s. I think he helped in the designing and machining of the instrument bays on the nose, the large oval shaped crevices. I have some 1980s medallions, stickers and a patch that I've kept around, this video makes me want to go dig them out.
When the rockets separate and the sparks backwash towards the camera is visually stunning on the video.