Here is my case use [mostly sales specific]
I have a number of times when I am doing or want to do the same set of tasks in response to a catalyst.
Let's say I return from a sales appointment with a new client. There are a series of tasks that should occur as best practice. These include data entry and kicking off a series of follow ups ( a note card followed by an email followed by a voice mail follow by whatever else I can dream up).
So how do I insure these tasks get done? I can't find an app to do this. Well, that's not entirely true. When I was in real estate there was an awesome app called Top Producer. You could assign a contact to an "Action Plan". These plans could be modified to any level of complexity you want. Then, on a daily basis, when you came in in the morning all pending action items were auto-sorted by context (long before GTD). This allowed you sit down and send all emails (either templated/mail-merged emails or individually written emails); print all letters and/or envelopes; write all handwritten notes; make all calls; etc.
But now that I am removed from that world, I can not find any equivelent. I'm sure that there's gotta be some app (Sales Force, Act, Goldmine, etc.). But I work in an Outlook environment. I have tried other online apps, e.g. HighRise by 37 signals or Pipeline Deals.
The ability to auto-assign task specific tasks could be utilized on lots of scenarios. Really, too many to list here.
But the basic idea is very, very critical to me creating an efficient work flow for me and my team.
I would really appreciate any ideas or web sites or products or blogs or neighbors or psychic hotlines you can point me to that could solve this challenge for me.