Just like anything, a good time lapse depends on composition. I've been wanting to try this out so I found a parking structure and blasted away. I liked this location because it allowed me to see how cars and trains moved, along with the setting sun and clouds. This really makes you think long and hard about what you're shooting... You don't want an hour to go to waste!
Check out my first attempt ever here: https://www.youtube.com/watch?v=4czs1fDMuoY