I first became aware of shaders after Elder Scrolls: Morrowind was released. My water, in the game, didn't look like the amazing water in the pictures on the box.
I investigated the matter, and discovered that this new water effect was produced by programmable shaders, and I decided that I needed to understand them.
But first, I needed to run out and buy a new video card. Immediately.