There are more texture mapping approaches which can be added on top of normal mapping to make the illusion even better, such as parallax [1] or displacement [2] mapping.
------
IMO, its important to understand the limitations of pixel shading, because its an important step in the modern graphics pipeline.