I've added a link for CincinnatiRoads.com to my Links/Blogroll section.
CincinnatiRoads.com is map-based interface that shows videos of street segments within the city from the driver's point of view. You can clearly see the structures that line each street, and the stop lights and other wasted time are edited out.
So far they have clips of:
1) The CBD, between Central and Broadway
2) Over-the-Rhine, areas south of Liberty St (minus Pendleton)
3) Most of Mt. Adams
4) The Ohio River bridges between the Brent Spence and the Taylor Southgate
The plan is to continue adding street by street. It's an ambitious project, but definitely a cool one.