I don't know much about these things, but I'm fairly sure most of the time they are faked by shaders.
Considering the board we are on though, if you mention specific titles I think you'll be able to get really specific answers on how the effect was achieved in that particular game.