The most fascinating demo I have seen today which seems to have no immediate use is Hyperlapse – a service which works with Google Street View to generate movies based on coordinates you enter on a map by dragging and dropping pins. To be fair, the service does allow the user to become familiar with a road or course before traversing it. It is more useful for this purpose than Google Street View because you don’t have to traverse the map a few frames at a time by hand.
The service seems to work best or perhaps only on Google Chrome as it requires WebGL and it requires what it calls a “decent” machine which apparently I have. It is a fun site and worth checking out. Hopefully you can come up with something useful to do with the videos it produces.