I used this 2 years ago and it worked great, needed to use it again recently, still great. It basically allows me to conditionally load an additional stylesheet (for CSS overrides) depending on the page the user is on. I use it to change header graphics in sections.
One tip, I got stuck for bit, it seems the module doesn't output the CSS include code unless the physical CSS file with the correct name already exists. Once I figured that out I was fine.