This video was shot in July 2009 using a Canon XSI and a Canon TC-80N3 (intervalometer) with the 18-55mm. The view is from the Dreams Cancun hotel, 6th floor.
Here the camera setting: AV mode, F5.6, ISO 800 and tungsten WB. Exposure went from 1/4000 at the start to 4-5 seconds at night. Intervalometer was set to take a picture every 5 seconds. It took about 2500 pics until the battery died.