We have published a new whitepaper on MSDN that provides a scenario based roadmap on the database and CLR XML technologies. It provides some examples and criteria that should allow you to decide when to use which technology. The URL is http://msdn.microsoft.com/library/en-us/dnsql90/html/sql2k5xmloptions.asp.
Enjoy!