Can I get some constructive feedback about the following architecture? 

**Simplified Architecture Summary:**

*Return XML from your SQL Server (using FOR XML) and pass it straight into a XSL transform to produce a rich HTML web site.*

What are the pro’s and con’s of such a system when compared with a conventional 3-tier ASP.NET architecture?