It's difficult to tell from such a small pic, but it doesn't look like an 'effect' to me, just a nice bit of painting. Could have been done traditionally
but most likely in Photoshop like you say. All about having the right brushes, imagination, references etc.