CSS came about when it was needed the most, when the Web became commercially popular and HTML started to be written by graphic designers, not geeks with too much free time.
That it has not taken off as its creators may have envisioned can be put down to ignorance and inertia. As I've said elsewhere, my artistic talents are limited and frankly I'd rather bang on the keyboard to get my fevered thoughts the hell out of my brane and onto the Web than spend endless hours tweaking appearance and formatting. But I'm pleased to be able to harness a little bit of the power of style sheets, and even more pleased to find that the good folks at the W3C who are working on CSS are recognizing the really clever style sheet usage out there.
This page, if you are using a CSS-compliant browser, is formatted using the W3C's Chocolate style sheet. It's one of the eight or so Core Styles that the W3C encourages linking to, and if you don't like it there are plenty of other ones to choose from.
I guess that's what it is about - choice and accessibility, and since the beginning the Web has provided that for users and authors alike. The Web may not have lived up to its expectations, but it is very much a work in progess and we can safely assume that now, eleven years after its inception, we have just begun to discover what we can do.
A few of the neater links I've run across while refreshing my CSS skills follow -