I've tried setting up a Workflow Rule that is triggered by a Potential field and sends an E-mail Alert to the Account Contacts and ran into the following limitations.

1) If I base the workflow off of the Potentials module, I can only e-mail the one Contact that is chosen for that Potential.  Since this is a one-to-one relationship, I can't send the e-mail to all of the Account's contacts.  Also, Contacts are already associated with the Account, so why the extra two steps of associating one conact for the Contact field, then associating multiple Contact Roles with the potential?  None of this seems to make good sense.

2) The Contact Role module is nowhere to be found in the workflows, so manually adding Contact Roles to the Potential doesn't solve anything.

3) If I try to build it as a workflow from the Accounts module, I still can't select the account Contacts, so that doesn't work.

4) If I built a custom script, then the send email function doesn't use the templates and cannot send attachments.

This seems like a basic function for a workflow automation.  Am I missing something?  What alternatives are there?

I've considered using Campaigns instead of the CRM, but this won't be an automated solution and have not investigated it to see if this is even doable.

The promise of automation is nice, but it seems all of the routes I've tried to take to build this result in unfortunate dead ends.