I would imagine they can show up as just about anything wrong in what's displayed, but the most common thing I've seen when overclocking are discolored spots all over textures in games. Like in Q3 I saw blue and green spots on everything when my card was pushed just a bit too hard.