The "C" in CSS: The Cascade

Following up from Geoff's intro article on The Second "S" in CSS, let's now move the spotlight to the "C" in CSS - what we call the Cascade. It's where things start to get messy, and even confusing at times. Have you ever written a CSS property and the value doesn't seem to work?