The Forms Email Service Task works for simple emails, but anything involving logic or constructing HTML requires using Workflow instead. I'd like to see Workflow have the ability to address an email to the members of Forms team(s), and (optionally) to users having particular role(s) within that team.
For example, I have a very simple process by which teachers submit test results which Workflow stores in a SQL table. An administrator wants an email with a subset of the form data to monitor the process, but doesn't need the entire form attached. Finding the address to use for the email requires querying the Forms database.