It's simple really.
If a stockpile is filled with only one type of material (or the vast majority is that material), make the stockpiles appearance change based on that material. For example, a stockpile of Porphyry would look red, while Gneiss would look that generic blueish grey colour.
How am I suppose to show off my wealth when all my metal bar stockpiles look the same?