Here is a very good tutorial to create a HDR (High Dynamic Range) image. They look amazing and I am going to give one a go soon. The best thing is, I just found out that you can make a HDR image from a single RAW file. I always shoot RAW+JPEG so I can turn just about every picture I have taken into a HDR.
Heres the link: http://stuckincustoms.com/?p=548
Others which can be done in photoshop:
I will post more tutorials for HDR when I come across them. If you have any links regarding HDR tutorials or any HDR, please share.
If you have any questions regarding HDR, please feel free to ask.