I came accross this today, it's quite impressive what this guy can do with photoshop, and the site is a great before and after format.

http://homepage.mac.com/gapodaca/digital/digital.html

Matthew