Can anyone forward me to a good demo showing Indie shaders in action?
You dont need a special demo for it. The shaders are the same in every edition. They are part of the material editing. You apply textures and you choose a shader from a drop-down box. I remember normal, spec and parallax mapping. But there is much more than that.
And the advantage of in-built shaders is: They just work with shadows, fog, different lights, whatever, no need to worry about.