Source: For comparison, here's Las Vegas late at night. Even my NightPod camera found the lights too bright.
Some of Commander Hadfield's tweeted pictures collected on one webpage:
Link: Photos: Chris Hadfield tweets from Space | Windsor Star
Some of those photos are well, just amazing! :O