At Code School, we're using MailChimp for promotional and some automated onboarding sets.
We use Mandrill for transactionals and a few are combined with code within our Rails app.

I'd love to know your scenario...