Blog item that examines XQuery vs XSLT.
I would add to the insights here that XSLT is designed for transformations while XQuery was designed to find things that are not necessarily in the current instance you are working with but also not necessarily in a CMS or database.
An additional article from Michael Kay on the same subject.