Database Mail in 2005 is also very weak in formatting the results of a query sent via email. Basically, you get pure text only. If you want to actually transmit structured information or have your emails look pretty, you have to manually massage the query output to make it happen.

Also, aside from the HTML which Database Mail only partially supports (it doesn't make HTML; it just sets the emails content-type), and the PDF format which has already been mentioned, SQLAnswersMail supports a number of other formats, such as Excel and Word. It also has a variety of automation tools which can save development time such as combining multiple emails together and compressing attachments in ZIP format (with optional password).

Another feature is the ability to send web pages in the email. I don't mean HTML-formatted text, I mean actual remotely-retrieved web pages. Thus you can keep your HTML generation OUT of SQL and on the web where it belongs. Although I admin to using it in our environment (since we didn't have SQL Answers at the time), it doesn't seem like best practice to use SQL to cobble together an HTML document.