Tilt-shift photography is becoming a really big thing - it makes aerial photos look like tiny scale models. Here's a Christmas city scene done using tilt-shift.
You don't need an aeroplane or complicated cameras to do this, just a good photo-editiing program - see more on Flickr website.