Here's a demo I did in a recent class I instructed on concept design. By combining matte painting and photo editing techniques, you can quickly achieve something like this.
I'm not saying it's easy friends, BUT it does get easier over time with practice!
original photo here:[link]
I'm considering doing another demo like this on ustream.com.
Follow me there, as well as twitter so you know when it's happening.