When it works...
I would only recommend this product if you are on an environment that does not changes very often. Be careful when upgrading! Disable ALL your alerts first before upgrading or migrating your farm database.
I love the ability to trigger workflows.
Alerts tend to be very fragile. I spend a few days troubleshooting alerts related issues at least once a year, since we've got this tool.
We have this
Getting support from Bamboo is next to impossible. The alerts can work reliably but they must be set up just perfectly which can take a lot of time. We have it working on one list but can't for the life of us get it to work on another list in the site collection. The times are all wrong, etc. Support was, of course, no help with that either.