Is there a definitive guide for special folders in windows?

Question

Is there a definitive guide for special folders in windows? An internet search yielded just a few crumbs of information, e.g.

• Wikipedia:Special Folders
• Windows 7 Client Software Logo Program

What I'm looking for is an explanation of each folder, its intended purpose, usage scenarios and motivation for its existence (e.g. what does Local App settings provide for that App settings doesn't). A matrix/table of requirements/uses against folder would be handy I think.

Answer 1

How about the CSILD reference: http://msdn.microsoft.com/en-us/library/bb762494%28v=VS.85%29.aspx

and the KNOWNFOLDERID reference: http://msdn.microsoft.com/en-us/library/dd378457%28v=VS.85%29.aspx