Yesterday, I posted about tools for Querying SharePoint via CAML (previous post link) and I linked to a Web Page about CAML. I found that the page also listed a group of great How-to Examples using CAML.
Here's what you can do with CAML (from the page):
CAML allows you the ultimate flexibility and extensibility with your Web sites based on SharePoint Team Services from Microsoft. If you want to make a universal change to all the sites that you are creating within your company — for instance, you want to change the logo to match your own company logo, or you want to add an Employee ID field to your document libraries — you must use CAML to do it.

↑ Grab this Headline Animator
Here's the list of examples from the page (found here):
~Robert Shelton