DSDG packages are free and add downtown buildings and details, mostly for FS2004 but also for FSX.
New York, Dubai, Milano and Houston can be found on their website. Soon, Las Vegas 2013 will also get buildings modelled for FS2004 with custom ground and photoreal textures.